| From: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | "Robert Gobeille" <bob(dot)gobeille(at)hp(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_catalog forward compatibility |
| Date: | 2008-09-02 15:58:01 |
| Message-ID: | 162867790809020858u4a11c034tc2feb6868d86779b@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello
2008/9/2 Robert Gobeille <bob(dot)gobeille(at)hp(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Fetter | 2008-09-02 16:13:13 | Re: pg_catalog forward compatibility |
| Previous Message | Pavel Stehule | 2008-09-02 15:41:45 | Re: SQL equivalent to \dT |