On Jan 8, 2007, at 9:13 PM, Matthew Terenzio wrote:
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
Looks like WITH NULL AS '' might work
Michael Glaesemann
grzm seespotcode net
---------------------------(end of
broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
