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:59:13 |
Message-ID: | CAHyXU0wL8MjooSEfvyT8gJ4z7yUe3goO_t433h60pjbai5JLDw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Apr 20, 2012 at 10:51 AM, Vincenzo Romano
<vincenzo(dot)romano(at)notorand(dot)it> wrote:
> 2012/4/20 Merlin Moncure <mmoncure(at)gmail(dot)com>:
>> 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
>
> Ok. That works. How can I know if there's a temporary view with the
> same name in my session?
well, arguably you should already know somehow. but if you don't,
query information_schema.views for a table_name with a table_schema
LIKE 'pg_temp%'.
merlin
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2012-04-20 16:07:06 | Re: How to drop a temporary view? |
Previous Message | Vincenzo Romano | 2012-04-20 15:51:03 | Re: How to drop a temporary view? |