On Fri, 20 Apr 2012 17:36:59 +0200 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. DROP VIEW <view> It will destroy the view, temporary or not... Regards Rodrigo > > -- > Vincenzo Romano - NotOrAnd.IT > Information Technologies > NON QVIETIS MARIBVS NAVTA PERITVS > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
