Re: PostgreSQL Metadata

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.
>