copy from - Mailing list pgsql-sql

From Adam Lang
Subject copy from
Date
Msg-id 02b701c0062f$081e31c0$330a0a0a@Adam
Whole thread Raw
List 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 by date:

Previous
From: Jesus Aneiros
Date:
Subject: Re: select an entry with a NULL date field
Next
From: "Madel, Kurt"
Date:
Subject: Creating A Rule to Increment a class size when a student adds tha t class to their schedule