From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: How to drop a temporary view? |
Date: | 2012-04-20 16:51:12 |
Message-ID: | CAHyXU0zafdwcvELTGfrQ0K-WEJoez=ZVgupsbsG15LLGukAePQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Apr 20, 2012 at 11:07 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Merlin Moncure <mmoncure(at)gmail(dot)com> writes:
>> 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%'.
>
> Not sure that is safe --- won't the info schema also show temp views
> of other sessions?
nope, it works (you only get to see your own temporary views
information_schema). i guess you could make an arguable case to fold
the temp schema name to a constant to hide the pg_temp_zz
implementation detail.
merlin
From | Date | Subject | |
---|---|---|---|
Next Message | Vincenzo Romano | 2012-04-20 16:51:40 | Re: How to drop a temporary view? |
Previous Message | Merlin Moncure | 2012-04-20 16:47:29 | Re: pg_advisory_lock() and row deadlocks |