Обсуждение: How to check is the table system

Поиск
Список
Период
Сортировка

How to check is the table system

От
Андрей
Дата:
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

От
Michael Glaesemann
Дата:
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