| 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 |