Thread: How to check is the table system

How to check is the table system

From
Андрей
Date:
Hello!

How can I get table's comment, created like this:
   COMMENT ON TABLE people IS '...comment...' ?
What system table keeps comments on databases, schemas and tables?

    Big Thanks,
        Andrei



Re: How to check is the table system

From
Michael Glaesemann
Date:
On Oct 20, 2005, at 18:22 , Андрей wrote:

> How can I get table's comment, created like this:
>   COMMENT ON TABLE people IS '...comment...' ?
> What system table keeps comments on databases, schemas and tables?

Here are a couple of links to documents that might help.

http://www.postgresql.org/docs/8.0/interactive/functions-
info.html#FUNCTIONS-INFO-COMMENT-TABLE
http://www.postgresql.org/docs/8.0/interactive/catalogs.html

Michael Glaesemann
grzm myrealbox com