Yes PostgreSQL does support COMMENTing on wide
range of objects in the same manner as Oracle.
rt3=# \h comment
Description: define or change the comment of an object
TABLE object_name |
COLUMN table_name.column_name |
AGGREGATE agg_name (agg_type) |
CONSTRAINT constraint_name ON table_name |
DATABASE object_name |
DOMAIN object_name |
FUNCTION func_name (arg1_type, arg2_type, ...) |
INDEX object_name |
OPERATOR op (leftoperand_type, rightoperand_type) |
RULE rule_name ON table_name |
SCHEMA object_name |
SEQUENCE object_name |
TRIGGER trigger_name ON table_name |
TYPE object_name |
] IS 'text'
David Wagoner wrote:
> In Oracle, you can "select * from dictionary" to see the data
> dictionary table names and descriptions. Is there something similar
> in PostgreSQL?
> Also, in Oracle you can store comments on tables and columns which
> provides valuable metadata. Is this also possible in PostgreSQL?
> Here is an example create table statement in Oracle with comments:
> CREATE TABLE lock_date
> lock_id NUMBER(9) NOT NULL,
> TABLESPACE data
> -- Comments for LOCK_DATE
> COMMENT ON TABLE lock_date IS 'Locks out data that arrives after
> Billing and Reporting periods.'
> -- Column Comments for LOCK_DATE
> COMMENT ON COLUMN lock_date.lock_id IS 'Surrogate Primary Key
> for the LOCK_DATE table.'
> Best regards,
> *David B. Wagoner*
> Database Administrator
> Arsenal Digital Solutions
> Web: http://www.arsenaldigital.com
> The contents of this e-mail message may be privileged and/or
> confidential. If you are not the intended recipient, any review,
> dissemination, copying, distribution or other use of the contents of
> this message or any attachment by you is strictly prohibited. If you
> receive this communication in error, please notify us immediately by
> return e-mail or by telephone (919-466-6700), and please delete this
> message and all attachments from your system.
> Thank you.
In response to
pgsql-admin by date
|Next:||From: Rajesh Kumar Mallah||Date: 2003-11-01 07:37:55|
|Subject: Logging query durations into another table in PostgreSQL 7.4|
|Previous:||From: Jamie Lawrence||Date: 2003-10-31 22:28:31|
|Subject: Security, proxies, etc. (was: Re: performance problem - 10.000 databases)|