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 13938.1449702261@sss.pgh.pa.us
Whole thread Raw
In response to 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?  (Eric Ridge <eebbrr@gmail.com>)
List pgsql-hackers
Tree view 
Eric Ridge <eebbrr@gmail.com> writes:
> I'm doing some extension development (in C) and have a situation where I
> need to examine the target list of a view, but all I have is the view's oid.

Open the relation and use get_view_query(), perhaps.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Making tab-complete.c easier to maintain
Next
From: Merlin Moncure
Date:
Subject: Re: [sqlsmith] Failed to generate plan on lateral subqueries