COPY with column list

From: Brent Verner <brent(at)rcfile(dot)org>
To: pgsql-patches(at)postgresql(dot)org
Subject: COPY with column list
Date: 2002-07-10 06:12:14
Message-ID: 20020710061214.GA24579@rcfile.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

The attached patch (against HEAD) implements

COPY x (a,d,c,b) from stdin;
COPY x (a,c) to stdout;

as well as the corresponding changes to pg_dump to use the new
functionality. This functionality is not available when using
the BINARY option. If a column is not specified in the COPY FROM
statement, its default values will be used.

In addition to this functionality, I tweaked a couple of the
error messages emitted by the new COPY <options> checks.

cheers.
brent

--
"Develop your talent, man, and leave the world something. Records are
really gifts from people. To think that an artist would love you enough
to share his music with anyone is a beautiful thing." -- Duane Allman

Attachment Content-Type Size
copy-colspec.2002071001.diff text/plain 22.8 KB

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message sugita 2002-07-10 10:11:35 install-sh patch for Mac OS X
Previous Message Bruce Momjian 2002-07-10 04:05:13 Re: implementing query timeout