On 3/17/25 07:57, Sylvain Cuaz wrote:
Hi all,
I have a DB with one schema named "Common" holding data referenced
by other schemas. All other schemas have the same structure (tables and
fields) and are named "cXXX" where XXX is just an int. Thus the only
cross-schema foreign keys are in "cXXX" pointing to "Common", and each
"cXXX" is completely independent of other "cXXX" schemas.
Now if I want to restore from a full dump of this DB, but with only
one "cXXX" and the "Common" schema :
- if I pass --create --schema=Common, then the CREATE SCHEMA is missing,
i.e. it only emits data inside "Common" and the restore fails.
I am not seeing that.
For:
pg_dump -d test -U postgres -s --create --schema=other_sch --schema=public
In the output I get:
[...]
CREATE SCHEMA other_sch;
ALTER SCHEMA other_sch OWNER TO postgres;
--
-- Name: public; Type: SCHEMA; Schema: -; Owner: pg_database_owner
--
CREATE SCHEMA public;
ALTER SCHEMA public OWNER TO pg_database_owner;
[...]
What is the complete command you are using for the pg_dump?
What Postgres version(s) are you using?
Cheers,
Sylvain
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
