Re: SQL text of view - Mailing list pgsql-general

From Pavel Stehule
Subject Re: SQL text of view
Date
Msg-id Pine.LNX.4.44.0311241808090.16974-100000@kix.fsv.cvut.cz
Whole thread Raw
In response to SQL text of view  ("Yury Shvetsov" <rmtech@marbella.net>)
List pgsql-general
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
>


pgsql-general by date:

Previous
From: "Jason Tesser"
Date:
Subject: pam authentication for postgres
Next
From: Christian Traber
Date:
Subject: Re: autocommit in 7.4