smart copy?

From: Lucas Rockwell <lr(at)socrates(dot)Berkeley(dot)EDU>
To: pgsql-admin(at)postgresql(dot)org
Subject: smart copy?
Date: 2002-04-26 19:58:56
Message-ID: Pine.GSO.4.40.0204261250280.10392-100000@socrates.Berkeley.EDU
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Nick Fankhauser 2002-04-26 20:49:48 Re: Permission on tables
Previous Message Steven Cuthbertson 2002-04-26 19:23:34 Re: Permission on tables