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:[EMAIL PROTECTED]
> Sent: Tuesday, December 27, 2005 12:11 PM
> To: pgsql-sql@postgresql.org
> Cc: [EMAIL PROTECTED]
> Subject: Re: The I
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'
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
