On May 22, 2002 10:28 am, you wrote:
> Right now the only safe way to dump such a database is to use the
> inserts-with-explicit-column-names option. Someone was working on
> extending COPY to allow a column name list, and as soon as that gets
> done I intend to change pg_dump to specify a column name list in
> COPY commands. That should fix this problem.
Do you mean issue COPY commands with fields or COPY out the fields in a
specific order by using the extension in pg_dump? Seems like the latter
would be cleaner but the former is probably a lot simpler to do.
What would the new syntax of the COPY look like?
--
D'Arcy J.M. Cain <darcy@{druid|vex}.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.