copy - fields enclosed by, ignore x lines
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
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@yahoo.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
Import Notes
Resolved by subject fallback
Use python's (or another language) CSV reader module which will parse the
quotes for you and write the values in a tab-delimited file. Don't forget
to escape the tabs in the strings... it should be less than 10 lines of
code.
On Mon, 25 Oct 2004 14:45:57 -0700 (PDT), CSN
<cool_screen_name90001@yahoo.com> wrote:
Show quoted text
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---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?