Re: CSV import

Поиск
Список
Период
Сортировка
От Jeff Eckermann
Тема Re: CSV import
Дата
Msg-id 20030128224533.71751.qmail@web20809.mail.yahoo.com
обсуждение исходный текст
Ответ на CSV import  (Oliver Vecernik <vecernik@aon.at>)
Список pgsql-sql
--- Oliver Vecernik <vecernik@aon.at> wrote:
> Is there a direct way to import such files into
> PostgreSQL?
> 

As I believe others have replied: no, not yet.

If you are absolutely sure that your data will _never_
contain commas, then the simple solution of just
deleting all of the quotes , then using COPY with
comma delimiters, will work.  Otherwise, parsing CSV
files gets just too complicated, and you are better
off using an existing solution (like a Perl module) to
preprocess your data.

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com


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