| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Adam Witney <awitney(at)sghms(dot)ac(dot)uk> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Can COPY skip columns? |
| Date: | 2004-11-18 17:11:56 |
| Message-ID: | 419CD7DC.8050908@commandprompt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)commandprompt(dot)com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL
| Attachment | Content-Type | Size |
|---|---|---|
| jd.vcf | text/x-vcard | 640 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-11-18 17:15:38 | Re: Can COPY skip columns? |
| Previous Message | Adam Witney | 2004-11-18 17:11:20 | Re: Can COPY skip columns? |