From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
---|---|
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:45:46 |
Message-ID: | CAHyXU0x327Nc4_sZWvErJ6kj14w+mkzatfHBGW4kNESx+gJjcg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Apr 20, 2012 at 10:36 AM, 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.
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
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Angelico | 2012-04-20 15:46:28 | Re: pg_advisory_lock() and row deadlocks |
Previous Message | Rodrigo Gonzalez | 2012-04-20 15:44:32 | Re: How to drop a temporary view? |