smart copy? - Mailing list pgsql-admin

From Lucas Rockwell
Subject smart copy?
Date
Msg-id Pine.GSO.4.40.0204261250280.10392-100000@socrates.Berkeley.EDU
Whole thread Raw
Responses Re: smart copy?  ("Joel Burton" <joel@joelburton.com>)
List pgsql-admin
hi all,

is there a "smart" version of copy that will allow you to copy in data
when you have a column that is a default nextval(...) but you have no
data for that column?

basically, i want to import data into a table and the primary
key value does not exist in my data to import. is this possible?

the "Copy" section of Bruce's book doesn't cover this situation -- unless
i'm missing something. i skimmed the copy man page and didn't see any
mention there either.

thanks.

-lucas


pgsql-admin by date:

Previous
From: "Steven Cuthbertson"
Date:
Subject: Re: Permission on tables
Next
From: "Nick Fankhauser"
Date:
Subject: Re: Permission on tables