Hey guys,
In SQL Server, if you need to move a table with an identity column (a default sequence) with its data over to another database, you can create the table, turn off the identity column, bulk copy the data into the table, then turn the identity column back on. Is there a convenient way to do this in postgreSQL with a column that has a default sequence value?
Or I guess I'm asking if I can add a default sequence into a column after I've created the table and added data to it?
Roy.