using copy to insert data.

Поиск
Список
Период
Сортировка
От Jennifer Lee
Тема using copy to insert data.
Дата
Msg-id 75D535F36@law.scri.sari.ac.uk
обсуждение исходный текст
Ответы Re: using copy to insert data.  (Andrew McMillan <andrew@catalyst.net.nz>)
Re: using copy to insert data.  (Antti Haapala <haapala@mail.student.oulu.fi>)
Список 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 по дате отправления:

Предыдущее
От: "Molenda, Mark P"
Дата:
Сообщение: Html output
Следующее
От: Steve_Miller@sil.org
Дата:
Сообщение: Re: Favorite Linux Editor for PostgreSQL Scripts?/keyboards