2012/4/20 Merlin Moncure <mmoncure@xxxxxxxxx>: > On Fri, Apr 20, 2012 at 10:36 AM, Vincenzo Romano > <vincenzo.romano@xxxxxxxxxxx> 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? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
