Re: table and column comment

> -----Original Message-----
> From: jack [mailto:datactrl@tpg.com.au]
> Sent: 26 February 2002 02:23
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] table and column comment
>
>
> Hi, Dave
>
> I'm using pgadmin2 to develope an apllication on postgreSQL
> server. Would you please advise if I want to use sql
> statements to retrieve or update table and column comment,
> what can I do? Thank you!

Hi Jack,

In pgAdmin, just view the properties for the table or column (right-click
the icon in the treeview, and select 'Properties') and edit the comment in
the dialogue box.

In your application, use the COMMENT ON sql command to set the comments, and
either retrieve the comments from the pg_description table directly, or in
PostgreSQL 7.2 I believe there are some functions to do it for you.

Regards, Dave