How to check is the table system

Started by Андрейover 20 years ago2 messagesgeneral
Jump to latest
#1Андрей
andyk@softwarium.net

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

#2Michael Glaesemann
grzm@seespotcode.net
In reply to: Андрей (#1)
Re: How to check is the table system

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