Re: pg_views definition format

On Wed, 13 May 2009, Kevin Field wrote:

> Or would the only way to do this be to actually create a view and then
> call pg_get_viewdef() and then delete the view?

Just make it a temporary view and then it drops when the session ends. 
Here's a working shell example that transforms a view into the parsed form 
and returns it:

$ v="select * from pg_views"
$ p=`psql -Atc "create temporary view x as ${v}; select pg_get_viewdef('x'::regclass);"`
$ echo $p
SELECT pg_views.schemaname, pg_views.viewname, pg_views.viewowner, pg_views.definition FROM pg_views;

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD