Re: DDL for database creation

2019-03-08 Thread Ron
On 3/8/19 9:20 PM, Tom Lane wrote: Bruce Momjian writes: On Sat, Mar 9, 2019 at 02:13:57AM +, 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 woul

Re: DDL for database creation

2019-03-08 Thread Tom Lane
Bruce Momjian writes: > On Sat, Mar 9, 2019 at 02:13:57AM +, 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 enco

Re: DDL for database creation

2019-03-08 Thread Bruce Momjian
On Sat, Mar 9, 2019 at 02:13:57AM +, 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,

DDL for database creation

2019-03-08 Thread Julie Nishimura
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 c