Re: tracking errors in psql

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