| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Matthew Terenzio <matt(at)jobsforge(dot)com> |
| Cc: | PostgreSQL general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: COPY FROM and sequences |
| Date: | 2007-01-09 22:34:30 |
| Message-ID: | 20070109223430.GB11072@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Jan 08, 2007 at 20:20:42 -0500,
Matthew Terenzio <matt(at)jobsforge(dot)com> wrote:
> Is it true that you can't use COPY FROM to fill a table with a SERIAL
> type column?
>
> Or rather, how does one approach that situation most effectively?
In older versions of postgres you couldn't, in recent versions, you can
provide an explicit column list to COPY and the other columns will get
default values. You can't do this row by row though; there is no equivalent
to DEFAULT as used in INSERT statements for COPY.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Kroeger | 2007-01-09 22:39:28 | Re: ERROR: invalid memory alloc request size, and others |
| Previous Message | Tom Lane | 2007-01-09 22:31:05 | Re: ERROR: invalid memory alloc request size, and others |