| From: | Matthew Terenzio <matt(at)jobsforge(dot)com> |
|---|---|
| To: | Michael Glaesemann <grzm(at)seespotcode(dot)net> |
| Cc: | PostgreSQL general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: COPY FROM and sequences |
| Date: | 2007-01-09 02:13:43 |
| Message-ID: | 247a779404297822b4f0878ec6dcdfea@jobsforge.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Jan 8, 2007, at 8:55 PM, Michael Glaesemann wrote:
>
> On Jan 8, 2007, at 19:20 , Matthew Terenzio 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?
>
> Could you give an example of what you're trying to do? What errors are
> you getting?
Just trying to fill a large number of rows in a table that uses a
serial for the primary key, from a comma delimited file
invalid input syntax for integer: ""
I'm not quoting anything, just leaving the the delimited field empty
and expected a seuqence would fill the column as it would in an insert
>
> Michael Glaesemann
> grzm seespotcode net
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matthew Terenzio | 2007-01-09 02:20:47 | Re: COPY FROM and sequences |
| Previous Message | Guy Rouillier | 2007-01-09 02:05:38 | Re: SELECT INTO using Views? |