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 [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly




---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to