Re: Can COPY skip columns?

["Joshua D. Drake" <jd@xxxxxxxxxxxxxxxxx>]

Adam Witney wrote:
> Hi Joshua,
>
> Sorry, I meant skip a column in the file, not the database table, or is that
> what you meant?

No, I read your question backwards. I am sorry. As Tom Lane said, copy 
the file into a temporary table and then you can deal with it from there.

Sincerely,


Joshua D. Drake



> Thanks
>
> adam
>
>
>
>
> > 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@xxxxxxxxxxxxxxxxx - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL

begin:vcard
fn:Joshua D. Drake
n:Drake;Joshua D.
org:Command Prompt, Inc.
adr:;;PO Box 215;Cascade Locks;Oregon;97014;USA
email;internet:jd@xxxxxxxxxxxxxxxxx
title:Consultant
tel;work:503-667-4564
tel;fax:503-210-0334
note:Command Prompt, Inc. is the largest and oldest US based commercial PostgreSQL support provider. We  provide the only commercially viable integrated PostgreSQL replication solution, but also custom programming, and support. We authored  the book Practical PostgreSQL, the procedural language plPHP, and adding trigger capability to plPerl.
x-mozilla-html:FALSE
url:http://www.commandprompt.com/
version:2.1
end:vcard

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)