Yes PostgreSQL does support COMMENTing on wide
range of objects in the same manner as Oracle.
rt3=# \h comment
Command: COMMENT
Description: define or change the comment of an object
Syntax:
COMMENT ON
[ 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 | VIEW object_name
] IS 'text'
rt3=#
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
<<...OLE_Obj...>>
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.