Re: PostgreSQL Metadata

Great, thank you both for your replies.

Best regards,

David B. Wagoner
Database Administrator
Arsenal Digital Solutions
Web: http://www.arsenaldigital.com <http://www.arsenaldigital.com/>

"the most trusted source for
STORAGE MANAGEMENT SERVICES"

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.

-----Original Message-----
From: David Wagoner
Sent: Thursday, October 30, 2003 1:30 PM
To: PGSQL List (E-mail)
Subject: [ADMIN] PostgreSQL Metadata

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