Re: How do i give comment for each Field - Mailing list pgsql-general

From Thalis A. Kalfigopoulos
Subject Re: How do i give comment for each Field
Date
Msg-id Pine.LNX.4.21.0107161143250.9097-100000@aluminum.cs.pitt.edu
Whole thread Raw
In response to How do i give comment for each Field  (Radha <han_radha@yahoo.com>)
List pgsql-general
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
>


pgsql-general by date:

Previous
From: "Mitch Vincent"
Date:
Subject: Re: html to postgres...
Next
From: Tony Grant
Date:
Subject: Re: html to postgres...