copy - fields enclosed by, ignore x lines

Поиск
Список
Период
Сортировка
От CSN
Тема copy - fields enclosed by, ignore x lines
Дата
Msg-id 20041025214557.24808.qmail@web52907.mail.yahoo.com
обсуждение исходный текст
Ответы Re: copy - fields enclosed by, ignore x lines  (Pierre-Frédéric Caillaud<lists@boutiquenumerique.com>)
Список pgsql-general
Any chance of changing \copy and COPY to allow
specifying what the fields are enclosed by (such as
quotes) and to ignore the first x number of lines? I
have data like below and don't know of an easy way to
finesse it for importing (a simple regexp would remove
quotes, but I just got tripped up on commas *within*
values).

"field1","field2","field3"
"val1","val2","val3"



__________________________________
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
http://promotions.yahoo.com/new_mail

В списке pgsql-general по дате отправления:

Предыдущее
От: Gaetano Mendola
Дата:
Сообщение: Re: (S)RPMs for PostgreSQL 7.2.6, 7.3.8 and 7.4.6 are ready
Следующее
От: Gaetano Mendola
Дата:
Сообщение: Re: PgSQL MVCC vs MySQL InnoDB