Postgres Pro
Downloads
Home   >   mailing lists

SQL text of view - Mailing list pgsql-general

From Yury Shvetsov
Subject SQL text of view
Date
Msg-id 01d701c3acf4$d18d6c50$04001aac@dragonfly
Whole thread Raw
Responses Re: SQL text of view  (Mike Mascari <mascarm@mascari.com>)
Re: SQL text of view  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Alex Satrapa
Date:
Subject: Query Planner Filtering Of Specified Value From 'On Distinct' Clause
Next
From: Lynn.Tilby@asu.edu
Date:
Subject: Better Unilization of Memory