COPY and double-quote-separated fields
От | Ron Johnson |
---|---|
Тема | COPY and double-quote-separated fields |
Дата | |
Msg-id | 1059896211.24817.129.camel@haggis обсуждение исходный текст |
Ответы |
Re: COPY and double-quote-separated fields
|
Список | pgsql-general |
Hi, PostgreSQL 7.3.3 on i386-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3 (Debian) I must load a file in which each field in each row is contained in double quotes, i.e. "1","foo" "2","bar" "3","puddle" test1=# copy foo from '/usr/local/data/zip/foo.unl'; ERROR: copy: line 1, pg_atoi: error in ""1","foo"": can't parse ""1","foo"" I have a very large dataset (14.3GiB in 22 files) that has such a format, and would prefer not to sed each one of them, creating new files in the process. Any suggestions? Many TIA -- +-----------------------------------------------------------------+ | Ron Johnson, Jr. Home: ron.l.johnson@cox.net | | Jefferson, LA USA | | | | "I'm not a vegetarian because I love animals, I'm a vegetarian | | because I hate vegetables!" | | unknown | +-----------------------------------------------------------------+
В списке pgsql-general по дате отправления: