| From: | Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz> |
|---|---|
| To: | Yury Shvetsov <rmtech(at)marbella(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: SQL text of view |
| Date: | 2003-11-24 17:09:04 |
| Message-ID: | Pine.LNX.4.44.0311241808090.16974-100000@kix.fsv.cvut.cz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)postgresql(dot)org
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | tc | 2003-11-24 17:40:23 | Re: autocommit in 7.4 |
| Previous Message | Jason Tesser | 2003-11-24 17:05:55 | pam authentication for postgres |