------
-- OSDB : The Open Source Database Network
--
-- http://www.osdb.org
------
--
-- pgsql_states_us.sql
--
-- NOTE: This script does not create indexes.


create table states (
    name character varying(40) not null,
    code character varying(2) not null
);


insert into states (name, code) values ('Alaska', 'AK');
insert into states (name, code) values ('Alabama', 'AL');
insert into states (name, code) values ('Arizona', 'AZ');
insert into states (name, code) values ('Arkansas', 'AR');
insert into states (name, code) values ('California', 'CA');
insert into states (name, code) values ('Colorado', 'CO');
insert into states (name, code) values ('Connecticut', 'CT');
insert into states (name, code) values ('Delaware', 'DE');
insert into states (name, code) values ('District of Columbia', 'DC');
insert into states (name, code) values ('Florida', 'FL');
insert into states (name, code) values ('Georgia', 'GA');
insert into states (name, code) values ('Hawaii', 'HI');
insert into states (name, code) values ('Idaho', 'ID');
insert into states (name, code) values ('Illinois', 'IL');
insert into states (name, code) values ('Indiana', 'IN');
insert into states (name, code) values ('Iowa', 'IA');
insert into states (name, code) values ('Kansas', 'KS');
insert into states (name, code) values ('Kentucky', 'KY');
insert into states (name, code) values ('Louisiana', 'LA');
insert into states (name, code) values ('Maine', 'ME');
insert into states (name, code) values ('Maryland', 'MD');
insert into states (name, code) values ('Massachusetts', 'MA');
insert into states (name, code) values ('Michigan', 'MI');
insert into states (name, code) values ('Minnesota', 'MN');
insert into states (name, code) values ('Mississippi', 'MS');
insert into states (name, code) values ('Missouri', 'MO');
insert into states (name, code) values ('Montana', 'MT');
insert into states (name, code) values ('Nebraska', 'NE');
insert into states (name, code) values ('Nevada', 'NV');
insert into states (name, code) values ('New Hampshire', 'NH');
insert into states (name, code) values ('New Jersey', 'NJ');
insert into states (name, code) values ('New Mexico', 'NM');
insert into states (name, code) values ('New York', 'NY');
insert into states (name, code) values ('North Carolina', 'NC');
insert into states (name, code) values ('North Dakota', 'ND');
insert into states (name, code) values ('Ohio', 'OH');
insert into states (name, code) values ('Oklahoma', 'OK');
insert into states (name, code) values ('Oregon', 'OR');
insert into states (name, code) values ('Pennsylvania', 'PA');
insert into states (name, code) values ('Rhode Island', 'RI');
insert into states (name, code) values ('South Carolina', 'SC');
insert into states (name, code) values ('South Dakota', 'SD');
insert into states (name, code) values ('Tennessee', 'TN');
insert into states (name, code) values ('Texas', 'TX');
insert into states (name, code) values ('Utah', 'UT');
insert into states (name, code) values ('Vermont', 'VT');
insert into states (name, code) values ('Virginia', 'VA');
insert into states (name, code) values ('Washington', 'WA');
insert into states (name, code) values ('West Virginia', 'WV');
insert into states (name, code) values ('Wisconsin', 'WI');
insert into states (name, code) values ('Wyoming', 'WY');