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. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly