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 обсуждение исходный текст |
| Список | pgsql-general |
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 по дате отправления: