Re: [GENERAL] Schemas and serials

Поиск
Список
Период
Сортировка
От tel medola
Тема Re: [GENERAL] Schemas and serials
Дата
Msg-id CANRMYmhd=3SgA633yKSgfOZ4-Ck=9Yf30xWLaTJF6n5oXu_5_w@mail.gmail.com
обсуждение исходный текст
Ответ на [GENERAL] Schemas and serials  (marcelo <marcelo.nicolet@gmail.com>)
Ответы Re: [GENERAL] Schemas and serials
Список pgsql-general
Depends.
When you create your tables in new schema, the script was the same from "qa"?
Sequences, tables, etc.. belong to the schema where was created.

Roberto.

Em sáb, 29 de jul de 2017 às 16:17, marcelo <marcelo.nicolet@gmail.com> escreveu:
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


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

В списке pgsql-general по дате отправления:

Предыдущее
От: marcelo
Дата:
Сообщение: [GENERAL] Schemas and serials
Следующее
От: Melvin Davidson
Дата:
Сообщение: Re: [GENERAL] Schemas and serials