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
identitycolumn 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.