using copy to insert data. - Mailing list pgsql-novice

From Jennifer Lee
Subject using copy to insert data.
Date
Msg-id 75D535F36@law.scri.sari.ac.uk
Whole thread Raw
Responses Re: using copy to insert data.
Re: using copy to insert data.
List pgsql-novice
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


pgsql-novice by date:

Previous
From: "Molenda, Mark P"
Date:
Subject: Html output
Next
From: Steve_Miller@sil.org
Date:
Subject: Re: Favorite Linux Editor for PostgreSQL Scripts?/keyboards