[Ilugc] Obtaining the view definition using a query

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


Hi,

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