From: Ken Winter <ken@sunward.org>
To: PostgreSQL pg-sql list <pgsql-sql@postgresql.org>
Subject: The Information Schema vs the PG Catalog
Date: Fri, 23 Dec 2005 13:24:03 -0500
Message-ID: <001801c607ee$0dbed960$6603a8c0@kenxp> (raw)
I'm writing PL/pgSQL routines that generate triggers, functions, and rules
based on design characteristics of tables, columns, and other database
objects. These routines need to be able to look up the definitions of these
objects. I see that there are two places available to look up this info:
the Information Schema and in the PG Catalog.
Which source is preferable? Or if that answer isn't absolute, what are the
reasons or conditions for preferring one over the other?
Also, a specific question: Does the Information Schema offer any way to
list the sequences that exist and their attributes? I can't seem to find
any.
~ TIA
~ Ken
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ken@sunward.org
Subject: Re: The Information Schema vs the PG Catalog
In-Reply-To: <001801c607ee$0dbed960$6603a8c0@kenxp>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox