| From: | "Roderick A(dot) Anderson" <raanders(at)tincan(dot)org> |
|---|---|
| To: | t(dot)ngockhoi(at)bpf(dot)vnu(dot)com |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Table and Fields comment |
| Date: | 2001-10-23 12:15:50 |
| Message-ID: | Pine.LNX.4.10.10110230513230.12978-100000@tincan.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 23 Oct 2001 t(dot)ngockhoi(at)bpf(dot)vnu(dot)com wrote:
> Any body can't tell me howto add somme table fields comment. I don't
> find it in any meta-data table ?.
This is for PostgreSQL 7.1.3
raanders=> \h comment
Command: COMMENT
Description: Add comment to an object
Syntax:
COMMENT ON
[
[ DATABASE | INDEX | RULE | SEQUENCE | TABLE | TYPE | VIEW ]
object_name |
COLUMN table_name.column_name|
AGGREGATE agg_name agg_type|
FUNCTION func_name (arg1, arg2, ...)|
OPERATOR op (leftoperand_type rightoperand_type) |
TRIGGER trigger_name ON table_name
] IS 'text'
Rod
--
Let Accuracy Triumph Over Victory
Zetetic Institute
"David's Sling"
Marc Stiegler
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steven Vajdic | 2001-10-23 12:22:51 | Re: Postgres 7.1.3. installation on Windows platforms |
| Previous Message | Andrew Gould | 2001-10-23 12:10:33 | Re: Database design? |