blob: 244e495176a12158058e76cfc712d5c57066ca9c (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
|
COPY usastates FROM stdin WITH DELIMITER '|';
AK|Alaska |Àëÿñêà
WA|Washington |Âàøèíãòîí
OR|Oregon |Îðåãîí
CA|California |Êàëèôîðíèÿ
NV|Nevada |Íåâàäà
ID|Idaho |Àéäàõî
UT|Utah |Þòà
AZ|Arizona |Àðèçîíà
MT|Montana |Ìîíòàíà
WY|Wyoming |Âàéîìèíã
CO|Colorado |Êîëîðàäî
NM|New Mexico |Íüþ-Ìåêñèêî
ND|North Dakota |Ñåâåðíàÿ Äàêîòà
SD|South Dakota |Þæíàÿ Äàêîòà
NE|Nebraska |Íåáðàñêà
KA|Kansas |Êàíçàñ
OK|Oklahoma |Îêëàõîìà
TX|Texas |Òåõàñ
MN|Minnesota |Ìèííåñîòà
IA|Iowa |Àéîâà
MO|Missouri |Ìèññóðè
AR|Arkansas |Àðêàíçàñ
LA|Louisiana |Ëóèçèàíà
WI|Wisconsin |Âèñêîíñèí
IL|Illinois |Èëëèíîéñ
IN|Indiana |Èíäèàíà
MS|Mississippi |Ìèññèñèïè
AL|Alabama |Àëàáàìà
MI|Michigan |Ìè÷èãàí
OH|Ohio |Îãàéî
KY|Kentucky |Êåíòóêêè
TN|Tennessee |Òåííåññè
GA|Georgia |Äæîðäæèÿ
FL|Florida |Ôëîðèäà
PA|Pennsylvania |Ïåíñèëüâàíèÿ
WV|West Virginia |Çàïàäíàÿ Âèðäæèíèÿ
VA|Virginia |Âèðäæèíèÿ
NC|North Carolina|Ñåâåðíàÿ Êàðîëèíà
SC|South Carolina|Þæíàÿ Êàðîëèíà
NY|New York |Íüþ-Éîðê
NJ|New Jersey |Íüþ-Äæåðñè
DE|Delaware |Äåëàâýð
MD|Maryland |Ìýðèëåíä
DC|Washington DC |îêðóã Êîëóìáèÿ (ñîçäàí ñïåöèàëüíî ïîä ñòîëèöó)
VT|Vermont |Âåðìîíò
MA|Massachusetts |Ìàññà÷óñåòñ
CT|Connecticut |Êîííåêòèêóò
ME|Maine |Ìýí
NH|New Hampshire |Íüþ-Ãýìïøèð
RI|Rhode Island |Ðîä-Àéëåíä
\.
SELECT * FROM usastates ORDER BY name_ru;
|
