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>
Cc: <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: Using COPY in the migration wizard.
Date: 2002-12-11 22:28:09
Message-ID: 03AF4E498C591348A42FC93DEA9661B8128D51@mail.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

> -----Original Message-----
> From: Kurt Roeckx [mailto:Q(at)ping(dot)be]
> Sent: 11 December 2002 22:25
> To: Dave Page
> Cc: pgadmin-hackers(at)postgresql(dot)org
> Subject: Re: [pgadmin-hackers] Using COPY in the migration wizard.
>
>
> On Wed, Dec 11, 2002 at 10:19:22PM -0000, 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, without odbc? It's
> only the postgresql part that has to use COPY, not when
> reading the data.

Not in pgAdmin II, that uses ODBC/ADO. pgAdmin III which is in
development uses libpq.

Regards, Dave.

Browse pgadmin-hackers by date

  From Date Subject
Next Message Henshall, Stuart - Design & Print 2002-12-12 16:22:51 Re: pgadmin3 compiles on msys
Previous Message Kurt Roeckx 2002-12-11 22:25:03 Re: Using COPY in the migration wizard.