Re: [GENERAL] Schemas and foreign keys - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: [GENERAL] Schemas and foreign keys
Date
Msg-id 2265ebc5-cb8f-01d6-d129-68bb5e40879f@a-kretschmer.de
Whole thread Raw
In response to [GENERAL] Schemas and foreign keys  (marcelo <marcelo.nicolet@gmail.com>)
Responses Re: [GENERAL] Schemas and foreign keys
List pgsql-general

Am 21.07.2017 um 14:58 schrieb marcelo:
> 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
>
>

that's no problem:

test=# create schema demo1;
CREATE SCHEMA
test=*# create schema demo2;
CREATE SCHEMA
test=*# create table master_table(id int primary key);
CREATE TABLE
test=*# create table demo1.demo_table(id int primary key, master_id int
references public.master_table);
CREATE TABLE
test=*# create table demo2.demo_table(id int primary key, master_id int
references public.master_table);
CREATE TABLE


Regards, Andreas

--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] pg_restore misuse or bug?
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] pg_dump and insert json with copy