> -Original Message-
> From: Kurt Roeckx [mailto:[EMAIL PROTECTED]]
> Sent: 11 December 2002 22:25
> To: Dave Page
> Cc: [EMAIL PROTECTED]
> Subject: Re: [pgadmin-hackers] Using COPY in the migration wizard.
>
>
> On Wed, Dec 11, 2002 at 10:19:22PM -, Dave Page wrote:
> > >
> > >
On Wed, Dec 11, 2002 at 10:19:22PM -, Dave Page wrote:
> >
> > 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.
Don't you directly access postgresql,
> -Original Message-
> From: Kurt Roeckx [mailto:[EMAIL PROTECTED]]
> Sent: 11 December 2002 22:12
> To: [EMAIL PROTECTED]
> 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
The migration wizard is very slow because it does an insert of
all the records. Would it be possible to use COPY instead?
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 goin