Re: Table and Fields comment

On Tue, 23 Oct 2001 t.ngockhoi@bpf.vnu.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