[Ilugc] Obtaining the view definition using a query
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.
Arise Awake and stop not till the goal is reached.
- Swami Vivekananda
Mail: benignbala at gmail.com
More information about the ilugc