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