Re: How to add description for databases and tables? - Mailing list pgsql-novice

From Pandu Poluan
Subject Re: How to add description for databases and tables?
Date
Msg-id CAA2qdGXwNn3=xS0g1v8nKJj89qut2_OyxsNAni_pQQC=7Rw0dg@mail.gmail.com
Whole thread Raw
In response to Re: How to add description for databases and tables?  (Basil Bourque <basil.list@me.com>)
List pgsql-novice
On Wed, Dec 7, 2011 at 14:50, Basil Bourque <basil.list@me.com> wrote:
>>> Using \d+ exposes a column "Description". Now, how do I add a
>>> Description to a table and/or a column? There does not seem to be any
>>> option during CREATE DATABASE or CREATE TABLE.
>>
>> http://www.postgresql.org/docs/9.1/static/sql-comment.html
>
> The pgAdmin app lets you enter text in the "Comment" field of a table or column's Properties dialog.
>

Hmm... but that means I have to knock open a port on the firewall (the
PostgreSQL box is cloud-hosted)...

... doable, if less secure. I'll look into it.

Thanks!

Rgds,
--
FdS Pandu E Poluan
~ IT Optimizer ~

 • LOPSA Member #15248
 • Blog : http://pepoluan.tumblr.com
 • Linked-In : http://id.linkedin.com/in/pepoluan

pgsql-novice by date:

Previous
From: Basil Bourque
Date:
Subject: Re: How to add description for databases and tables?
Next
From: Ioannis Anagnostopoulos
Date:
Subject: Re: Linux server connection process consumes all memory