COPY syntax improvement
От | Bruce Momjian |
---|---|
Тема | COPY syntax improvement |
Дата | |
Msg-id | 200206190613.g5J6Db215780@candle.pha.pa.us обсуждение исходный текст |
Ответы |
Re: COPY syntax improvement
Re: COPY syntax improvement Re: COPY syntax improvement |
Список | pgsql-hackers |
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.) For portability, it still supports the old syntax of BINARY after COPY, WITH OIDS after 'table' and USING DELIMITERS after 'filename'. I have sent the patch to the patches list. I have not modified pg_dump so that 7.3 dumps can be loaded into <=7.2 databases. I have modified psql \copy to _only_ use the new syntax, and to only send the new syntax to the backends. (We don't usually support new psql in to older databases anyway.) Not sure if I should document the old syntax somewhere because pg_dump uses WITH OIDS with the old syntax. I have not applied the patch. I am waiting for comments. -- 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
В списке pgsql-hackers по дате отправления: