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