| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Julie Nishimura <juliezain(at)hotmail(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: DDL for database creation |
| Date: | 2019-03-09 02:39:29 |
| Message-ID: | 20190309023929.2ps4qotfwhj2b4hw@momjian.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)momjian(dot)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 +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2019-03-09 03:20:12 | Re: DDL for database creation |
| Previous Message | Julie Nishimura | 2019-03-09 02:13:57 | DDL for database creation |