| From: | Rodrigo Gonzalez <listas(at)estrads(dot)com(dot)ar> |
|---|---|
| To: | Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: How to drop a temporary view? |
| Date: | 2012-04-20 15:44:32 |
| Message-ID: | 20120420124432.1248f9c7@estrads.com.ar |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 20 Apr 2012 17:36:59 +0200
Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)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.
DROP VIEW <view>
It will destroy the view, temporary or not...
Regards
Rodrigo
>
> --
> Vincenzo Romano - NotOrAnd.IT
> Information Technologies
> NON QVIETIS MARIBVS NAVTA PERITVS
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2012-04-20 15:45:46 | Re: How to drop a temporary view? |
| Previous Message | Merlin Moncure | 2012-04-20 15:43:59 | Re: pg_advisory_lock() and row deadlocks |