Re: [pgadmin-hackers] Using COPY in the migration wizard.

2002-12-11 Thread Dave Page
> -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: > > > > > >

Re: [pgadmin-hackers] Using COPY in the migration wizard.

2002-12-11 Thread Kurt Roeckx
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,

Re: [pgadmin-hackers] Using COPY in the migration wizard.

2002-12-11 Thread Dave Page
> -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

[pgadmin-hackers] Using COPY in the migration wizard.

2002-12-11 Thread Kurt Roeckx
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