Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL Metadata

From: Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>
To: David Wagoner <dwagoner(at)arsenaldigital(dot)com>
Cc: "PGSQL List (E-mail)" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: PostgreSQL Metadata
Date: 2003-11-01 06:05:13
Message-ID: 3FA34D19.2020800@trade-india.com (view raw or flat)
Thread:
Lists: pgsql-admin
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.
>

In response to

pgsql-admin by date

Next:From: Rajesh Kumar MallahDate: 2003-11-01 07:37:55
Subject: Logging query durations into another table in PostgreSQL 7.4
Previous:From: Jamie LawrenceDate: 2003-10-31 22:28:31
Subject: Security, proxies, etc. (was: Re: performance problem - 10.000 databases)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group