Search Postgresql Archives

Re: pg_catalog forward compatibility

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello

2008/9/2 Robert Gobeille <bob.gobeille@xxxxxx>:
> 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@xxxxxxxxxxxxxx)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux