Le 17/03/2025 à 16:29, Tom Lane a écrit :
Sylvain Cuaz writes:
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
Le 17/03/2025 à 16:21, Adrian Klaver a écrit :
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
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 "cXX
