maintaining sequences - Mailing list pgsql-general

From roypgsqlgen@xemaps.com
Subject maintaining sequences
Date
Msg-id 200109131930.f8DJUQ700309@postgresql.org
Whole thread Raw
Responses Re: maintaining sequences
List pgsql-general
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.



pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Working with dates and queries
Next
From: "Mihai Gheorghiu"
Date:
Subject: Naming conventions