Postgres Pro
Downloads
Home   >   mailing lists

Re: DDL for database creation - Mailing list pgsql-general

From Bruce Momjian
Subject Re: DDL for database creation
Date
Msg-id 20190309023929.2ps4qotfwhj2b4hw@momjian.us
Whole thread Raw
In response to DDL for database creation  (Julie Nishimura <juliezain@hotmail.com>)
Responses Re: DDL for database creation  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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@momjian.us>        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 +

pgsql-general by date:

Previous
From: Julie Nishimura
Date:
Subject: DDL for database creation
Next
From: Tom Lane
Date:
Subject: Re: DDL for database creation