Hi,
I am using postgres 8.2. I would like to know if there is a
way to get the definition of a 'view' by running a query.
For eg., to get the list of views, we can do something like(of course,
there are other ways)
"SELECT table_name from infromation_schema.tables WHERE table_type = 'VIEW'"
Can we do something similar to get the definition of the view ? The
normal way of doing it is by running "\d+ view_name" in the postgres
database prompt. Thanks
--
Thank you
Balachandran Sivakumar
Arise Awake and stop not till the goal is reached.
- Swami Vivekananda
Mail: [email protected]
Blog: http://benignbala.wordpress.com/
_______________________________________________
ILUGC Mailing List:
http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
