Forwarding a post seen on an oracle list this morning as Stephane has been quite
an inspiration over the years and he is covering postgresql in this text:
Some list members may be adjunct or full-time faculty members and
interested by the fact that I'm currently working on a 450-page textbo
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.
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
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