User Tools

Site Tools


podoc:country_sql_table

Database Table Description of "country"

Name

country

Description

A list of all countries in the world.

Purpose

Referential integrity.

Schema

CREATE TABLE country (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  code                  VARCHAR(5),
  VALUE                 VARCHAR(40)
);

References tables

None.

Is referenced by tables

None.

None.

None.

History

Used first

Version 2.5

Used last

Still in use

Schema change history

= Version 2.5 =

CREATE TABLE country (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  code                  VARCHAR(5),
  VALUE                 VARCHAR(40)
);
Data change history

= Version 2.5 =

INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'ad', 'Andorra');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'ae', 'United Arab Emirates');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'af', 'Afghanistan');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'ag', 'Antigua and Barbuda');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'ai', 'Anguilla');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'al', 'Albania');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'am', 'Armenia');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'an', 'Netherlands Antilles');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'ao', 'Angola');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'aq', 'Antarctica');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'ar', 'Argentina');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'as', 'American Samoa');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'at', 'Austria');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'au', 'Australia');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'aw', 'Aruba');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'az', 'Azerbaijan');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'ba', 'Bosnia and Herzegovina');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'bb', 'Barbados');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'bd', 'Bangladesh');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'be', 'Belgium');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'bf', 'Burkina Faso');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'bg', 'Bulgaria');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'bh', 'Bahrain');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'bi', 'Burundi');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'bj', 'Benin');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'bm', 'Bermuda');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'bn', 'Brunei Darussalam');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'bo', 'Bolivia');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'br', 'Brazil');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'bs', 'Bahamas');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'bt', 'Bhutan');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'bv', 'Bouvet Island');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'bw', 'Botswana');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'by', 'Belarus');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'bz', 'Belize');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'ca', 'Canada');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'cc', 'Cocos (Keeling) Islands');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'cf', 'Central African Republic');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'cg', 'Congo');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'ch', 'Switzerland');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'ck', 'Cook Islands');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'cl', 'Chile');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'cm', 'Cameroon');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'cn', 'China');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'co', 'Colombia');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'cr', 'Costa Rica');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'cu', 'Cuba');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'cv', 'Cape Verde');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'cx', 'Christmas Island');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'cy', 'Cyprus');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'cz', 'Czech Republic');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'de', 'Germany');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'dj', 'Djibouti');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'dk', 'Denmark');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'dm', 'Dominica');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'do', 'Dominican Republic');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'dz', 'Algeria');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'ec', 'Ecuador');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'ee', 'Estonia');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'eg', 'Egypt');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'eh', 'Western Sahara');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'er', 'Eritrea');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'es', 'Spain');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'et', 'Ethiopia');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'fi', 'Finland');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'fj', 'Fiji');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'fk', 'Falkland Islands (Malvinas)');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'fm', 'Micronesia');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'fo', 'Faroe Islands');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'fr', 'France');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'fx', 'France Metropolitan');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'ga', 'Gabon');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'gb', 'Great Britain');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'gd', 'Grenada');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'ge', 'Georgia');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'gf', 'French Guiana');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'gh', 'Ghana');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'gi', 'Gibraltar');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'gl', 'Greenland');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'gm', 'Gambia');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'gn', 'Guinea');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'gp', 'Guadeloupe');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'gq', 'Equatorial Guinea');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'gr', 'Greece');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'gs', 'S. Georgia and S. Sandwich Isls.');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'gt', 'Guatemala');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'gu', 'Guam');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'gw', 'Guinea-Bissau');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'gy', 'Guyana');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'hk', 'Hong Kong');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'hm', 'Heard and McDonald Islands');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'hn', 'Honduras');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'hr', 'Croatia (Hrvatska)');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'ht', 'Haiti');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'hu', 'Hungary');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'id', 'Indonesia');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'ie', 'Ireland');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'il', 'Israel');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'in', 'India');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'io', 'British Indian Ocean Territory');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'iq', 'Iraq');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'ir', 'Iran');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'is', 'Iceland');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'it', 'Italy');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'jm', 'Jamaica');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'jo', 'Jordan');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'jp', 'Japan');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'ke', 'Kenya');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'kg', 'Kyrgyzstan');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'kh', 'Cambodia');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'ki', 'Kiribati');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'km', 'Comoros');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'kn', 'Saint Kitts and Nevis');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'kp', 'Korea (North)');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'kr', 'Korea (South)');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'kw', 'Kuwait');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'ky', 'Cayman Islands');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'kz', 'Kazakhstan');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'la', 'Laos');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'lb', 'Lebanon');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'lc', 'Saint Lucia');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'li', 'Liechtenstein');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'lk', 'Sri Lanka');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'lr', 'Liberia');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'ls', 'Lesotho');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'lt', 'Lithuania');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'lu', 'Luxembourg');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'lv', 'Latvia');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'ly', 'Libya');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'ma', 'Morocco');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'mc', 'Monaco');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'md', 'Moldova');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'mg', 'Madagascar');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'mh', 'Marshall Islands');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'mk', 'Macedonia');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'ml', 'Mali');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'mm', 'Myanmar');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'mn', 'Mongolia');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'mo', 'Macau');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'mp', 'Northern Mariana Islands');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'mq', 'Martinique');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'mr', 'Mauritania');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'ms', 'Montserrat');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'mt', 'Malta');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'mu', 'Mauritius');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'mv', 'Maldives');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'mw', 'Malawi');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'mx', 'Mexico');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'my', 'Malaysia');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'mz', 'Mozambique');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'na', 'Namibia');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'nc', 'New Caledonia');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'ne', 'Niger');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'nf', 'Norfolk Island');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'ng', 'Nigeria');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'ni', 'Nicaragua');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'nl', 'Netherlands');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'no', 'Norway');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'np', 'Nepal');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'nr', 'Nauru');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'nt', 'Neutral Zone');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'nu', 'Niue');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'nz', 'New Zealand (Aotearoa)');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'om', 'Oman');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'pa', 'Panama');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'pe', 'Peru');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'pf', 'French Polynesia');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'pg', 'Papua New Guinea');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'ph', 'Philippines');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'pk', 'Pakistan');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'pl', 'Poland');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'pm', 'St. Pierre and Miquelon');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'pn', 'Pitcairn');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'pr', 'Puerto Rico');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'pt', 'Portugal');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'pw', 'Palau');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'py', 'Paraguay');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'qa', 'Qatar');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 're', 'Reunion');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'ro', 'Romania');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'ru', 'Russian Federation');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'rw', 'Rwanda');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'sa', 'Saudi Arabia');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'sb', 'Solomon Islands');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'sc', 'Seychelles');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'sd', 'Sudan');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'se', 'Sweden');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'sg', 'Singapore');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'sh', 'St. Helena');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'si', 'Slovenia');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'sj', 'Svalbard and Jan Mayen Islands');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'sk', 'Slovak Republic');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'sl', 'Sierra Leone');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'sm', 'San Marino');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'sn', 'Senegal');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'so', 'Somalia');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'sr', 'Suriname');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'st', 'Sao Tome and Principe');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'sv', 'El Salvador');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'sy', 'Syria');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'sz', 'Swaziland');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'tc', 'Turks and Caicos Islands');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'td', 'Chad');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'tf', 'French Southern Territories');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'tg', 'Togo');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'th', 'Thailand');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'tj', 'Tajikistan');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'tk', 'Tokelau');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'tm', 'Turkmenistan');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'tn', 'Tunisia');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'to', 'Tonga');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'tp', 'East Timor');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'tr', 'Turkey');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'tt', 'Trinidad and Tobago');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'tv', 'Tuvalu');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'tw', 'Taiwan');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'tz', 'Tanzania');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'ua', 'Ukraine');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'ug', 'Uganda');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'uk', 'United Kingdom');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'um', 'US Minor Outlying Islands');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'us', 'United States');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'uy', 'Uruguay');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'uz', 'Uzbekistan');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'va', 'Vatican City State (Holy See)');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'vc', 'Saint Vincent and the Grenadines');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 've', 'Venezuela');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'vg', 'Virgin Islands (British)');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'vi', 'Virgin Islands (U.S.)');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'vn', 'Viet Nam');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'vu', 'Vanuatu');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'wf', 'Wallis and Futuna Islands');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'ws', 'Samoa');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'ye', 'Yemen');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'yt', 'Mayotte');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'yu', 'Yugoslavia');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'za', 'South Africa');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'zm', 'Zambia');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'zr', 'Zaire');
INSERT INTO country VALUES (NEXTVAL('country_id_sequence'), 'zw', 'Zimbabwe');
podoc/country_sql_table.txt · Last modified: 2007/04/20 13:40 by Luud