On Mon, 16 Jul 2001, Radha wrote:
>
>
> Hi,
>
> I need to store some comments/definition for every field in a
> table. Is there a way to give comment for the columns while creating the
> table itself or after that?
>
> I see something like 'Description' when i want to see the list of
> tables/fields in the table using '\d'. Have anyone used this
> 'Description'?
>
> Any help would be appreciated. Thanx in advance.
You can add comments for the fields after table creation using the COMMENT command in
psql. Do \h COMMENT to see the syntax.
cheers,
thalis
>
> bye
> Radha
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
