On Wed, Mar 9, 2011 at 3:06 AM, Gnanakumar <gnanam(at)zoniac(dot)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;
???