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. regards, tom lane
