Steve Wampler wrote > Let me generalize the problem a bit: How can I specify that the default > value of a column > is to be used with a COPY command when some rows have values for that > column and > some don't?
If you provide a value for a column, including NULL, the default expression is not evaluated. COPY is dumb but fast. If you need logic you need to add it yourself. Either before the copy or copy into a temporary UNLOGGED table and write smart SQL to migrate from that to the live table. You can also put smarts into a trigger. Personally I would generally stage all the data then write two INSERT INTO ... SELECT statements; one for the known values and one where you omit the column and let the system use the default. David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/COPY-data-into-a-table-with-a-SERIAL-column-tp5823278p5823291.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
