On 3/8/19 9:20 PM, Tom Lane wrote:
Bruce Momjian <bruce@xxxxxxxxxx> writes:
On Sat, Mar 9, 2019 at 02:13:57AM +0000, Julie Nishimura wrote:
Is there a way to reconstruct DDL for creation of existing databases? For
example, I need to create dev environment for some (not all) of our existing
databases, and I would like to keep the same encoding, connection limit (if
anything was specified), etc. Is there a way to create this DDL?
pg_dump --schema-only maybe?
The specific settings the OP mentions are database-level settings;
so she'd need pg_dumpall (perhaps with -g), or pg_dump with -C.
Why not "pg_dumpall --schema-only" in combination with "pg_dumpall -g"?
https://www.postgresql.org/docs/9.6/app-pg-dumpall.html
-s
--schema-only
Dump only the object definitions (schema), not data.
--
Angular momentum makes the world go 'round.
