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

COPY commands could use an enhancement.

From: Alfred Perlstein <bright(at)wintelcom(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: COPY commands could use an enhancement.
Date: 2001-04-30 09:35:51
Message-ID: 20010430023551.X18676@fw.wintelcom.net (view raw or flat)
Thread:
Lists: pgsql-hackers
It would be very helpful if the COPY command could be expanded
in order to provide positional parameters.

I noticed that it didn't a while back and it can really hurt
someone when they happen to try to use pg_dump to move data
from one database to another database and they happened to
create the feilds in the tables in different orders.

Basically:
COPY "webmaster" FROM stdin;

could become:
COPY "webmaster" FIELDS "id", "name", "ssn" FROM stdin;

this way when sourcing it would know where to place the
feilds.

-- 
-Alfred Perlstein - [alfred(at)freebsd(dot)org]
Daemon News Magazine in your snail-mail! http://magazine.daemonnews.org/

Responses

pgsql-hackers by date

Next:From: Vince VielhaberDate: 2001-04-30 10:03:22
Subject: Re: Thanks, naming conventions, and count()
Previous:From: Alfred PerlsteinDate: 2001-04-30 06:17:20
Subject: Re: Thanks, naming conventions, and count()

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