On Jan 8, 2007, at 9:20 PM, Matthew Terenzio wrote:
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
I see! you've just got to specify the columns in the COPY FROM
statement and it will use the defaults for those columns not listed
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
---------------------------(end of
broadcast)---------------------------
TIP 6: explain analyze is your friend
