How to drop a temporary view? - Mailing list pgsql-general

From Vincenzo Romano
Subject How to drop a temporary view?
Date
Msg-id CAHjZ2x7iCeEf+vmw3dASYnyxSx5oSdkue3WrysXtH4s13ByStQ@mail.gmail.com
Whole thread Raw
Responses Re: How to drop a temporary view?  (Rodrigo Gonzalez <listas@estrads.com.ar>)
Re: How to drop a temporary view?  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
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.

--
Vincenzo Romano - NotOrAnd.IT
Information Technologies
NON QVIETIS MARIBVS NAVTA PERITVS

pgsql-general by date:

Previous
From: Eliot Gable
Date:
Subject: pg_advisory_lock() and row deadlocks
Next
From: Merlin Moncure
Date:
Subject: Re: pg_advisory_lock() and row deadlocks