Re: Can COPY skip columns? - Mailing list pgsql-general

Adam Witney wrote:
> Hi,
>
> Is it possible for the COPY command to read data from a file, but skip
> specific columns?

\h copy

COPY tablename [ ( column [, ...] ) ]
     TO { 'filename' | STDOUT }
     [ [ WITH ]
           [ BINARY ]
           [ OIDS ]
           [ DELIMITER [ AS ] 'delimiter' ]
           [ NULL [ AS ] 'null string' ]
           [ CSV [ QUOTE [ AS ] 'quote' ]
                 [ ESCAPE [ AS ] 'escape' ]
                 [ FORCE QUOTE column [, ...] ]

Yes.. you just have to specify the columns...

Sincerely,

Joshua D. Drake


>
> Thanks
>
> Adam
>
>


--
Command Prompt, Inc., home of PostgreSQL Replication, and plPHP.
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL