PostgreSQL INFORMATION_SCHEMA explained

April 28, 2006

[From Lorenzo Alberton]

New tutorial on how to retrieve PostgreSQL db metadata from the INFORMATION_SCHEMA when available (PostgreSQL v.7.4 or later), or querying the catalogs (pg_class, pg_user, pg_view, etc) in older pgsql versions.

The guide provides some queries to extract the table structure, triggers, views or constraint definitions, and more.

The article continues at http://www.alberton.info/postgresql_meta_info.html








The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers