Skip site navigation (1) Skip section navigation (2)

Re: Using COPY in the migration wizard.

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Kurt Roeckx" <Q(at)ping(dot)be>, <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: Using COPY in the migration wizard.
Date: 2002-12-11 22:19:22
Message-ID: 03AF4E498C591348A42FC93DEA9661B8128D50@mail.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-hackers

> -----Original Message-----
> From: Kurt Roeckx [mailto:Q(at)ping(dot)be] 
> Sent: 11 December 2002 22:12
> To: pgadmin-hackers(at)postgresql(dot)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.

Responses

pgadmin-hackers by date

Next:From: Kurt RoeckxDate: 2002-12-11 22:25:03
Subject: Re: Using COPY in the migration wizard.
Previous:From: Kurt RoeckxDate: 2002-12-11 22:11:47
Subject: Using COPY in the migration wizard.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group