Tom Lane wrote:
Sounds like you created all that stuff in template1, and so it's being
copied into the new database.
Yup, that's it. Thanks!
Rachel
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Rachel Willmer <[EMAIL PROTECTED]> writes:
> DROP DATABASE testdb;
> CREATE DATABASE testdb;
> Database appears again. But so does the schema 'edinburgh', all its
> tables, views, data, etc.
Sounds like you created all that stuff in template1, and so it's being
copied into the new database. Rea
I have a database 'testdb' with two schemas: 'public' and edinburgh'.
Public is empty, everything is in 'edinburgh'.
DROP DATABASE testdb;
Database no longer appears in list of databases in cluster. So far, so good.
CREATE DATABASE testdb;
Database appears again. But so does the schema 'edinbu
