mmediately 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 PMTo: PGSQL List
(E-mail)Subject: [ADMIN] 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_t
On Thu, 30 Oct 2003, 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?
Old way (still supported, not going away):
\d from a psql session
New way: select * from information_s
Title: 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