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>
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 (view raw or flat)
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.

pgadmin-hackers by date

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

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