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@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026