From: | "Ken Winter" <ken(at)sunward(dot)org> |
---|---|
To: | "PostgreSQL pg-sql list" <pgsql-sql(at)postgresql(dot)org> |
Subject: | The Information Schema vs the PG Catalog |
Date: | 2005-12-23 18:24:03 |
Message-ID: | 001801c607ee$0dbed960$6603a8c0@kenxp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Terry Lee Tucker | 2005-12-23 19:13:16 | Re: Merry Xmas and a Happy New Year |
Previous Message | Achilleus Mantzios | 2005-12-23 14:16:38 | Merry Xmas and a Happy New Year |