Carol Walter <walterc@xxxxxxxxxxx> writes: > ... Why does this come back > with all the tables intact when I drop it and recreate a database > with the same name? Most likely, you accidentally created all that stuff in template1, and CREATE DATABASE is just copying it from there. Clean out template1. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin