Gavin Sherry writes: > The patch attached maintains backward compatibility. The syntax is as > follows: > > COPY [BINARY] <relname> [WITH OIDS] FROM/TO > [USING DELIMITERS <delimiter>] > [WITH [ DELIMITER <delimiter> | NULL AS <char> | OIDS ]]
I think we should lose the WITH altogether. It's not any better than USING. But just saying "OIDS" is not very clear. In this case the WITH is necessary. > Note that if you execute a query such as: > > COPY pg_class TO '/some/path/file/out' > USING DELIMITERS <tab> > WITH DELIMITER '|'; > > The code will give preference to WITH DELIMITER. That should be an error. > If no one can find fault with this or my implementation, I'll follow up > with documentation and psql patches (not sure that there is much point > patching pg_dump). pg_dump should use the new syntax. -- Peter Eisentraut [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html