Re: Using COPY in the migration wizard.

> -----Original Message-----
> From: Kurt Roeckx [mailto:Q@ping.be]
> Sent: 11 December 2002 22:12
> To: pgadmin-hackers@postgresql.org
> Subject: [pgadmin-hackers] Using COPY in the migration wizard.
>
>
> The migration wizard is very slow because it does an insert
> of all the records.  Would it be possible to use COPY instead?

No because there is no interface for copy in the ODBC spec.

> What I can do in psql in less than a second takes 10 minutes
> or more using the wizard.  That is just for one of the
> smallest tables.  For the whole database it's probably going
> to take days at this rate.

Make sure you have logging turned off under Tools -> Options, and that
SQL tracing is switched of in the ODBC driver manager. To be honest
though, if you can get your data in a format for copy, then I would
suggest migrating the empty tables only using pgAdmin, then loading them
using psql.

Regards, Dave.