.
From: Sean Davis [mailto:[EMAIL PROTECTED]
Sent: Sunday, April 03, 2005 5:28 AMTo: Srikanth Utpala
(Virinchi); pgsql-general@PostgreSQL.orgSubject: Re: [GENERAL]
getting information of tables and indexes
You can query the information schema:
http://www.postgresql.org/docs/8.0/static
You can query the information schema:
http://www.postgresql.org/docs/8.0/static/information-schema.html
More specifically:
http://www.postgresql.org/docs/8.0/static/infoschema-columns.html
Hope that answers your question.
Sean
- Original Message -
From:
Srikanth Utpa
SELECT * FROM information_schema.tables;
SELECT * FROM information_schema.columns;
These should have most of the information you need.
Regards,
Paul Tillotson
Srikanth Utpala (Virinchi) wrote:
Hi
I am Srikanth. I want to get the information about all tables in the
existing postgresql . I want list
