SQL copy from csv with explicit field ordering

From: Terry Fielder <terry(at)greatgulfhomes(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: SQL copy from csv with explicit field ordering
Date: 2001-03-01 20:46:06
Message-ID: 3A9EB50E.C2770BEA@greatgulfhomes.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I guess this is really a SQL question:

I have a csv that I want to import, but the csv has different column
ordering.

I have tried putting the column names in the first row, but then the
copy command fails on field which is data type (eg it is seeing the
cells in first row as data, not header info).

ggtest=> copy ap_trans from '/var/dbase/ap_trans.csv' using delimiters
',';
ERROR: pg_atoi: error in "id": can't parse "id"

The help indicates:
ggtest=> \h copy
Command: copy
Description: copy data to and from a table
Syntax:
COPY [BINARY] class_name [WITH OIDS]
TO|FROM filename|STDIN|STDOUT [USING DELIMITERS 'delim'];

I have tried WITH OIDS but with same results.

Is there somewhere that I can either enable the first line of CSV as
header names

OR

Can I explicitly define my import field ordering from within the select
statement?

Thanks

Terry Fielder
terry(at)greatgulfhomes(dot)com

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 2001-03-01 20:46:11 Re: Weird NOT IN effect with NULL values
Previous Message Stephan Szabo 2001-03-01 19:10:21 Re: Weird NOT IN effect with NULL values