Re: pg_catalog forward compatibility - Mailing list pgsql-general

From Pavel Stehule
Subject Re: pg_catalog forward compatibility
Date
Msg-id 162867790809020858u4a11c034tc2feb6868d86779b@mail.gmail.com
Whole thread Raw
In response to pg_catalog forward compatibility  (Robert Gobeille <bob.gobeille@hp.com>)
List pgsql-general
Hello

2008/9/2 Robert Gobeille <bob.gobeille@hp.com>:
> Is there a better way to query a database definition than select from
> pg_catalog tables and views?  For example, when I put out a new software
> update, I need to verify that all the table, column, constraint, etc
> definitions are correct for the update.
>

information_schema

http://www.postgresql.org/docs/8.3/interactive/information-schema.html

Regards
Pavel Stehule

> Thanks,
> Bob
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

pgsql-general by date:

Previous
From: "Pavel Stehule"
Date:
Subject: Re: SQL equivalent to \dT
Next
From: David Fetter
Date:
Subject: Re: pg_catalog forward compatibility