Is there a better way to create a database from the schema of another
database, to have a copy of a database without the data?
1.) I get the schema from a database
pg_dump -s -U postgres -O databasename > /tmp/template_name
2.) I create a new database.
createdb -U postgres newdb
3.) I restore the schema to the newdb.
psql -U postgres newdb < /tmp/template_name
4.) I create a database, using the newdb as a TEMPLATE
CREATE DATABASE databasename2 TEMPLATE newdb;
Marc
