Postgres Pro
Downloads
Home   >   mailing lists

Re: Given a view relation OID, how to construct a Query? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Given a view relation OID, how to construct a Query?
Date
Msg-id 2752.1449706061@sss.pgh.pa.us
Whole thread Raw
In response to Re: Given a view relation OID, how to construct a Query?  (Eric Ridge <eebbrr@gmail.com>)
Responses Re: Given a view relation OID, how to construct a Query?
List pgsql-hackers
Tree view 
Eric Ridge <eebbrr@gmail.com> writes:
> On Wed, Dec 9, 2015 at 4:04 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Open the relation and use get_view_query(), perhaps.

> I figured there was something simple, but I couldn't find it.  Thanks!
> Sadly, it's static.

FWIW, it's exposed in 9.4 and up.  But in older branches you could
probably just copy it, it's not that big.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [sqlsmith] Failed to generate plan on lateral subqueries
Next
From: Eric Ridge
Date:
Subject: Re: Given a view relation OID, how to construct a Query?