importing from a file with UTF-8 escape characters

Поиск
Список
Период
Сортировка
Искать
От
Seb
Тема
importing from a file with UTF-8 escape characters
Дата
Msg-id
873a1b80bt.fsf@kolob.sebmags.homelinux.org
Список
Hi,

I'm trying to import the geonames table from
http://download.geonames.org/export/dump/allCountries.zip.  A PostgreSQL
user recommended using:

create table geonames (
         geonameid       int,
         name            varchar(200),
         asciiname        varchar(200),
         alternatenames  varchar(4000),
         latitude        float,
         longitude       float,
         fclass  char(1),
         fcode   varchar(10),
         country varchar(2),
         cc2 varchar(60),
         admin1  varchar(20),
         admin2  varchar(80),
         admin3  varchar(20),
         admin4  varchar(20),
         population      bigint,
         elevation       int,
         gtopo30         int,
         timezone varchar(40),
         moddate         date
 );

but some lines in the file have strings of the form:

5881673	{1}útsaw Lake	{1}utsaw Lake		62.699499389	-136.737319993	H	LK	CA		12				0		600	America/Dawson	2006-01-18

which I take as UTF-8 escaped characters.  Any tips on how to import
this into the table so that they print properly?  Thanks.

Cheers,

-- 
Seb
В списке pgsql-general по дате отправления
От: Ben Chobot
Дата:
От: Ben Chobot
Дата:
FAQ