<s400t@xxxxxxxxxxx> writes: > I am using Postgresql 9.6, and the latest phppgadmin. OS is Debian 9.6. > 1. Created a database. > 2. Created tables inside that database. > 3. Dropped that database. > Now, what happens is when I create another database with the same name or different name, all those tables are already inside that database!!! I have not run the table create script. I think you created some tables in the "template1" database, which is (by default) what CREATE DATABASE clones to make a new DB. Duplicating its contents is considered a feature not a bug. You could manually clean out template1, or if that seems painful, you could drop it and recreate it by cloning template0 (see CREATE DATABASE's TEMPLATE option). template0 exists precisely to be a virgin empty database for this sort of purpose. (There is an interlock to prevent you from dropping either of these template databases accidentally. Overriding that is left as an exercise for the student.) regards, tom lane
