Postgresql 7.3 will allow you to copy data into specific columns
copy table (col1, col2) from 'filepath' with delimiter ',';
HTH
Chad
----- Original Message -----
From: "Jennifer Lee" <jlee@scri.sari.ac.uk>
To: <pgsql-novice@postgresql.org>
Sent: Thursday, February 06, 2003 9:40 AM
Subject: [NOVICE] using copy to insert data.
> I'm trying to insert data from a delimited file using the copy command
> (COPY table FROM 'filepath') this works fine, but I would like to insert
> data into specific columns. I've read that this is possible but haven't
> been able to find documentation on how to do it. I've been able to
> insert the data as I'd like in two steps. 1. copy into a temporary table,
2.
> insert using select columns from the temporary table. Is there a way to
> do this in one step?
>
> Thanks much,
> Jennifer
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
