From: Ken Winter <ken@sunward.org>
To: 'George Pavlov' <gpavlov@mynewplace.com>
To: pgsql-sql@postgresql.org
Subject: Re: The Information Schema vs the PG Catalog
Date: Tue, 27 Dec 2005 14:32:52 -0500
Message-ID: <005001c60b1c$54b86bc0$6603a8c0@kenxp> (raw)
In-Reply-To: <CCB89282FCE1024EA3DCE687A96A516403895D2B@ehost010-6.exch010.intermedia.net>
Thanks, George. What you say fits with what I was finding. I think that's
the way I will go.
~ Ken
> -----Original Message-----
> From: George Pavlov [mailto:gpavlov@mynewplace.com]
> Sent: Tuesday, December 27, 2005 12:11 PM
> To: pgsql-sql@postgresql.org
> Cc: ken@sunward.org
> Subject: Re: The Information Schema vs the PG Catalog
>
> I would say that pg_catalog is the more complete one whereas the
> information_schema the more generic, standards-conformant place. I would
> stick with the information_schema unless that becomes inadequate. A case
> in point may be sequences. Apart from
> information_schema.columns.column_default I haven't seen them
> represented anywhere there (please someone correct me if I am wrong).
> You can get more information about sequences from pg_catalog.pg_class
> (look for pg_class.relkind='S') and various views that sit on top of
> that (e.g. pg_statio_all_sequences).
>
> George
>
>
> > 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.
> >
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, gpavlov@mynewplace.com
Subject: Re: The Information Schema vs the PG Catalog
In-Reply-To: <005001c60b1c$54b86bc0$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