Re: Mind of its own?

JD, IB, TL:

Yes!!! I found the whole bunch of tables in template 1!

It's so liberating. 

Thank you.

----- Original Message -----
> From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> To: s400t(at)yahoo(dot)co(dot)jp
> Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
> Date: 2019/2/28, Thu 17:24
> Subject: Re: Mind of its own?
>
>& lt;s400t(at)yahoo(dot)co(dot)jp> 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
>