Re: SQL text of view

Yury Shvetsov schrieb:
> Hi.
>
> Where is the SQL text of view stored in the database?
> I mean the text like "SELECT the_field FROM the_table".
> I can found the function's text in "pg_proc.proerc", but can't find the same
> for a view.
>
> Yury Shvetsov.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>
What about

SELECT definition
FROM pg_views
WHERE viewname = <name of view>

Thomas