Re: COPY with column list

The most reccent version of this patch has been added to the PostgreSQL
unapplied patches list at:

http://candle.pha.pa.us/cgi-bin/pgpatches

I will try to apply it within the next 48 hours.

---------------------------------------------------------------------------

Brent Verner wrote:
> 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, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026