From: | CSN <cool_screen_name90001(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org, pgsql hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | copy - fields enclosed by, ignore x lines |
Date: | 2004-10-25 21:45:57 |
Message-ID: | 20041025214557.24808.qmail@web52907.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Elphick | 2004-10-25 21:54:20 | Re: how to port Oracle database to PostgreSQL? |
Previous Message | Gaetano Mendola | 2004-10-25 21:42:17 | Re: PgSQL MVCC vs MySQL InnoDB |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-10-25 21:53:25 | Re: [PATCHES] ARC Memory Usage analysis |
Previous Message | Bruce Momjian | 2004-10-25 21:43:46 | Re: Using ALTER TABLESPACE in pg_dump |