copy from

Поиск
Список
Период
Сортировка
От Adam Lang
Тема copy from
Дата
Msg-id 02b701c0062f$081e31c0$330a0a0a@Adam
обсуждение исходный текст
Список pgsql-sql
I need additional help involving the copy from command

I have a database with several fields: id, name, address, zip

id is the primary key and I use nextval to get a value.

The file I want to upload is in comma separated value, that does not have a
primry key (or an id) field.

How would I use copy from and assign the correct id number?

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company



В списке pgsql-sql по дате отправления:

Предыдущее
От: Jesus Aneiros
Дата:
Сообщение: Re: select an entry with a NULL date field
Следующее
От: "Madel, Kurt"
Дата:
Сообщение: Creating A Rule to Increment a class size when a student adds tha t class to their schedule