Re: Generating synthetic keys on copy

From: Scott Ribe <scott_ribe(at)killerbytes(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Generating synthetic keys on copy
Date: 2006-10-05 15:12:23
Message-ID: C14A7CF7.56F1A%scott_ribe@killerbytes.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Right. Instead, specify a column list to the COPY (you are using a PG
> version new enough to have column lists in COPY, no?) and it will
> execute the default expression for the column(s) not coming from the data
> file.

Thanks. (Feeling dumb here.) I am using 8.1, however I haven't read the docs
for COPY in a few years, and didn't realize I could specify a column list.
RTFM, duh.

--
Scott Ribe
scott_ribe(at)killerbytes(dot)com
http://www.killerbytes.com/
(303) 722-0567 voice

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Leonel Nunez 2006-10-05 15:42:43 Re: Storing images in PostgreSQL databases (again)
Previous Message Chris Browne 2006-10-05 15:01:22 Re: Storing images in PostgreSQL databases (again)