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 <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org