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

Re: psql enhancement idea

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Uwe C(dot) Schroeder" <uwe(at)oss4u(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: psql enhancement idea
Date: 2004-10-21 22:03:16
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
"Uwe C. Schroeder" <uwe(at)oss4u(dot)com> writes:
> On Thursday 21 October 2004 12:40 pm, Tom Lane wrote:
>> I don't think that conclusion follows from that premise.  In recent
>> pg_dump versions (any that use a column list with COPY, which I think is
>> 7.3 or later) there is no fundamental disadvantage to using COPY; it
>> should be semantically equivalent to INSERT-with-column-list commands.

> The reason is that I made changes to the schema, i.e. changed the ordinal 
> position of columns and added some columns. Since the positioning of the 
> columns isn't the same anymore a copy will fail.

No, it won't, not if you use a column list.

			regards, tom lane

In response to


pgsql-admin by date

Next:From: Uwe C. SchroederDate: 2004-10-21 22:18:32
Subject: Re: psql enhancement idea
Previous:From: Uwe C. SchroederDate: 2004-10-21 22:00:20
Subject: Re: psql enhancement idea

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