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