PostgreSQL INFORMATION_SCHEMA explained

Friday Apr 28th 2006 by DatabaseJournal.com Staff
Share:

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.

[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

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved