Re: Drop only temporary table - Mailing list pgsql-general

From Tom Lane
Subject Re: Drop only temporary table
Date
Msg-id 15709.1458307643@sss.pgh.pa.us
Whole thread Raw
In response to Drop only temporary table  (Durumdara <durumdara@gmail.com>)
List pgsql-general
Durumdara <durumdara@gmail.com> writes:
> As I experienced I can create normal and temp table with same name.

Sure.

> As I see that drop table stmt don't have "temporary" suboption to determine
> which to need to eliminate - the real or the temporary.

Once you've created a temp table, it masks any normal table of the same name
(unless you use a schema-qualified reference to the normal table).

            regards, tom lane


pgsql-general by date:

Previous
From: Durumdara
Date:
Subject: Drop only temporary table
Next
From: Aleksander Alekseev
Date:
Subject: Re: Drop only temporary table