On Sat, Mar 9, 2019 at 02:13:57AM +0000, Julie Nishimura wrote: > Hello psql friends, > 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? -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription +