[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: how to clone a dataset?



david wrote:
I want to create a clone of a dataset except with a different dataset name and different users. Both versions need to be "live" simultaneously.



answering my own question:

from psql superuser:

postgres=# create database "new_db" template="old_db" owner="old_db_owner";