Re: Advise on dropping TEMP table/schema for my use case - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: Advise on dropping TEMP table/schema for my use case
Date
Msg-id AANLkTimyDFzfqQ2EVfQi0irjChpLO5Laej8O-aUQ0LR1@mail.gmail.com
Whole thread Raw
In response to Advise on dropping TEMP table/schema for my use case  ("Gnanakumar" <gnanam@zoniac.com>)
Responses Re: Advise on dropping TEMP table/schema for my use case  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
On Wed, Mar 9, 2011 at 3:06 AM, Gnanakumar <gnanam@zoniac.com> wrote:
>
> So, now we've decided to either DROP TABLE pg_temp_xx.FOO or DROP SCHEMA
> pg_temp_xx explicitly just before closing the connection (after step 3 and
> before step 4), so that it'll not be visible for the next database
> connection request.  My question is, which one of the option is recommended
> and why?

Why can't you just do:

DROP TABLE FOO;

???

pgsql-admin by date:

Previous
From: Vibhor Kumar
Date:
Subject: Re: FW: backup using pg_dump postgreSQL 8.3.8
Next
From: Andrew Sullivan
Date:
Subject: Re: [GENERAL] FW: backup using pg_dump postgreSQL 8.3.8