[GENERAL] Schemas and foreign keys

Поиск
Список
Период
Сортировка
От marcelo
Тема [GENERAL] Schemas and foreign keys
Дата
Msg-id 093d7dc5-3cfb-439b-8a27-fb7b779b48b9@gmail.com
обсуждение исходный текст
Ответы Re: [GENERAL] Schemas and foreign keys
Re: [GENERAL] Schemas and foreign keys
Список pgsql-general
Recently I asked regarding schemas, and received very useful answers. I
conclude that I can put some tables in one schema and left others in the
public one.
If my app selects some schema, the backend will found automatically the
absent tables in "public".
So far, so good.
But what about foreign keys? At least, I will have foreign keys from the
tables in the specified schema to the tables in "public", because I'm
thinking that the tables in "public" would be references, while the
tables residing in the specified schema will be the transactional ones.
TIA
Marcelo


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

Предыдущее
От: Thom Brown
Дата:
Сообщение: Re: [GENERAL] ~/.psqlrc file is ignored
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] pg_restore misuse or bug?