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: | Re: copy - fields enclosed by, ignore x lines |
Date: | 2004-10-25 21:56:34 |
Message-ID: | 20041025215634.28166.qmail@web52907.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Ah, looks like "enclosed by" will be in PG 8 :). Is
"QUOTE [ AS ] 'quote'" for the "enclosed by"
character?
Ignore x lines would be nice, but not as big of a
deal.
http://developer.postgresql.org/docs/postgres/sql-copy.html
--- CSN <cool_screen_name90001(at)yahoo(dot)com> wrote:
> 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
>
_______________________________
Do you Yahoo!?
Express yourself with Y! Messenger! Free. Download now.
http://messenger.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Elphick | 2004-10-25 21:58:59 | Re: ON DELETE trigger blocks delete from my table |
Previous Message | David Parker | 2004-10-25 21:55:28 | process hang during drop schema |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-10-25 22:00:42 | Re: Using ALTER TABLESPACE in pg_dump |
Previous Message | Tom Lane | 2004-10-25 21:53:25 | Re: [PATCHES] ARC Memory Usage analysis |