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  (Jason Godden <jasongodden@optushome.com.au>)
Список 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 по дате отправления:

Предыдущее
От: Ron Johnson
Дата:
Сообщение: Re: Inheritance & multiple-value fields
Следующее
От: Jason Godden
Дата:
Сообщение: Re: COPY and double-quote-separated fields