Re: [GENERAL] Question about weird COPY syntax

2010-06-17 Thread Tom Lane
Evan Carroll writes: > Why is it that "DELIMITER", and "NULL" options are under [WITH] but > not under [CSV]. This seems at least slightly awkward. They're not specific to CSV. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To ma

Re: [GENERAL] Question about weird COPY syntax

2010-06-17 Thread Tom Lane
Evan Carroll writes: > While asking questions about the grammar of COPY why do we have a > bracket of `[ [ WITH ] ...` rather than `[ WITH ]` ... Somebody left out the closing brackets in the documentation, evidently. Will fix. regards, tom lane -- Sent via pgsql-genera

Re: [GENERAL] Question about weird COPY syntax

2010-06-17 Thread Evan Carroll
While asking questions about the grammar of COPY why do we have a bracket of `[ [ WITH ] ...` rather than `[ WITH ]` ... COPY tablename [ ( column [, ...] ) ] FROM { 'filename' | STDIN } [ [ WITH ] (why is this opening bracket that is never closed here.) [