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
