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
- contact_info(country) references identifier
- location(country) references identifier
Related sequences
Related indexes
None.
Related functions
None.
Related views
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