Bruce Momjian wrote:
> I am working on the TODO item:
>
> o Change syntax to WITH DELIMITER, (keep old syntax around?)
>
> and I have added syntax so COPY can now accept all parameters at the end
> using WITH:
>
> COPY table
> FROM { 'filename' | stdin }
> [ [ WITH ]
> [ BINARY ]
> [ OIDS ]
> [ DELIMITER 'delimiter' ]
> [ NULL AS 'null string' ] ]
>
> (COPY TO is similar.)
Actually, in looking at the grammar, I see no reason NULL should have AS
while DELIMITER does not. New syntax has AS optional for both:
COPY table FROM { 'filename' | stdin } [ [ WITH ] [ BINARY ] [ OIDS ] [ DELIMITER [
AS] 'delimiter' ] [ NULL [ AS ] 'null string' ] ]
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026
