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
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:
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,
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: