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 по дате отправления: