Re: The DROP TABLE instruction should have a TEMP option for when a temporary table

[Tom Lane]

=?utf-8?q?PG_Doc_comments_form?= <nore...@postgresql.org> writes:
> The issue is related to the intention of drop the temporary table:
> ;DROP TABLE "myTooImportantTable"   -- <--- this drop the 
> "myTooImportantTable" 
> ;DROP TABLE "myTooImportantTable" -- <--- this drop the
> public."myTooImportantTable"

If you want to be sure you drop a temp table and not a regular one, say

DROP TABLE pg_temp.mytable;

There's no need for new syntax.

                        regards, tom lane