[Ilugc] Obtaining the view definition using a query

Balachandran Sivakumar benignbala at gmail.com
Thu Aug 30 12:21:31 IST 2012


On Thu, Aug 30, 2012 at 12:12 PM, Noorul Islam K M <noorul at noorul.com> wrote:
> Balachandran Sivakumar <benignbala at gmail.com> writes:
> Is this what you are looking for?
> SELECT definition FROM pg_views WHERE viewname like 'yourviewname' and
> schemaname NOT IN ('pg_catalog', 'information_schema');

     Thanks a lot :) That was what I was looking for.

Thank you
Balachandran Sivakumar

Arise Awake and stop not till the goal is reached.
                                                             - Swami Vivekananda

Mail: benignbala at gmail.com
Blog: http://benignbala.wordpress.com/

More information about the ilugc mailing list