On Fri, Apr 20, 2012 at 10:51 AM, Vincenzo Romano <vincenzo.rom...@notorand.it> wrote: > 2012/4/20 Merlin Moncure <mmonc...@gmail.com>: >> On Fri, Apr 20, 2012 at 10:36 AM, Vincenzo Romano >> <vincenzo.rom...@notorand.it> wrote: >>> Hi all. >>> I'd like use a temporary view "to hide" a non-temp one for some queries. >>> Later I'd need to drop that view in order to "revert to normal operations". >>> As there is no "DROP TEMPORARY VIEW ..." I'd be forced to "CREATE OR >>> REPLACE TEMPORARY VIEW ..." in order to "overwrite" the temporary one >>> with the same code as the non-temporary. >>> All this sounds quite complex to me. Is there a way to drop temporary >>> stuff before closing the session? >>> TIA. >> >> you can do it with vanilla DROP VIEW: >> >> postgres=# create temp view t as select 1; >> CREATE VIEW >> postgres=# drop view t; >> DROP VIEW >> >> merlin > > Ok. That works. How can I know if there's a temporary view with the > same name in my session?
well, arguably you should already know somehow. but if you don't, query information_schema.views for a table_name with a table_schema LIKE 'pg_temp%'. merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
