Postgres Example Data - U.S. State Names and Abbreviations

-- --------------------------------------------------
-- Make the table

CREATE TABLE IF NOT EXISTS public.us_states (
    db_id SERIAL PRIMARY KEY,
    abbreviation VARCHAR(2) NOT NULL UNIQUE,
    name VARCHAR(30)
);

-- --------------------------------------------------
-- Turn on row level security

ALTER TABLE public.us_states ENABLE ROW LEVEL SECURITY;


-- --------------------------------------------------
-- Add the abbreviations


INSERT INTO public.us_states (abbreviation, name)
VALUES ('AK', 'Alaska')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('AL', 'Alabama')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('AR', 'Arkansas')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('AZ', 'Arizona')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('CA', 'California')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('CO', 'Colorado')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('CT', 'Connecticut')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('DE', 'Delaware')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('FL', 'Florida')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('GA', 'Georgia')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('HI', 'Hawaii')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('IA', 'Iowa')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('ID', 'Idaho')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('IL', 'Illinois')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('IN', 'Indiana')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('KS', 'Kansas')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('KY', 'Kentucky')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('LA', 'Louisiana')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('MA', 'Massachusetts')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('MD', 'Maryland')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('ME', 'Maine')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('MI', 'Michigan')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('MN', 'Minnesota')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('MO', 'Missouri')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('MS', 'Mississippi')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('MT', 'Montana')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('NC', 'North Carolina')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('ND', 'North Dakota')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('NE', 'Nebraska')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('NH', 'New Hampshire')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('NJ', 'New Jersey')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('NM', 'New Mexico')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('NV', 'Nevada')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('NY', 'New York')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('OH', 'Ohio')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('OK', 'Oklahoma')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('OR', 'Oregon')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('PA', 'Pennsylvania')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('RI', 'Rhode Island')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('SC', 'South Carolina')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('SD', 'South Dakota')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('TN', 'Tennessee')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('TX', 'Texas')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('UT', 'Utah')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('VA', 'Virginia')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('VT', 'Vermont')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('WA', 'Washington')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('WI', 'Wisconsin')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('WV', 'West Virginia')
ON CONFLICT (abbreviation) DO NOTHING;

INSERT INTO public.us_states (abbreviation, name)
VALUES ('WY', 'Wyoming')
ON CONFLICT (abbreviation) DO NOTHING;