Some days ago I asked regarding tables located in different schemas. Now, my question is Suppose I have two schemas (other than public): "qa" and "production". Initially I create all my tables in "qa". All of them have a primary key of type serial. Later, I will copy the tables definitions to production. It will automatically create the sequences in the new schema, starting at zero? TIA Marcelo
Marcelo, >Initially I create all my tables in "qa". All of them have a primary key of type serial. >Later, I will copy the tables definitions to production.
A word of caution, creating tables in a qa "schema" and then transferring to production is not the normal/correct (or safe) way to do development.
The standard procedure is to create a seperate "qa" database (and/or server) with the exact same schema(s) as production. Then, after testing
is completed, the schemas/tables are copied to production.
--
Melvin Davidson I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.