Thread: SQL text of view

SQL text of view

From
"Yury Shvetsov"
Date:
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.prosrc", but can't find the same
for a view.

Yury Shvetsov.


Re: SQL text of view

From
Pavel Stehule
Date:
Hello

run psql with param -E and use metacommand \d nameofyourview

regards
Pavel


On Mon, 24 Nov 2003, Yury Shvetsov wrote:

> 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.prosrc", but can't find the same
> for a view.
>
> Yury Shvetsov.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>