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

Using COPY in the migration wizard.

From: Kurt Roeckx <Q(at)ping(dot)be>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: Using COPY in the migration wizard.
Date: 2002-12-11 22:11:47
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgadmin-hackers
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 going to take days
at this rate.

Is there a reason this isn't currently done?


pgadmin-hackers by date

Next:From: Dave PageDate: 2002-12-11 22:19:22
Subject: Re: Using COPY in the migration wizard.
Previous:From: Dave PageDate: 2002-12-10 13:50:20
Subject: Re: compiled pga3

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