brian wrote:
I've just gotten a dump from pgMyAdmin for a production database that i wanted to update the dev db with. However, i'm seeing a multitude of errors. From what i can see, the columns are mixed up in the COPY block for a particular table. My guess is that a tab character has thrown everything into disaray. The dump is structure & data, using COPY FROM STDIN.
1. This shouldn't happen. Dump/restore should work for all data with the standard pg_dump/pg_restore tools.
2. What is "pgMyAdmin" - I'm not sure I've heard of it. -- Richard Huxton Archonet Ltd