Bruce Momjian <bruce@momjian.us> 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
