| From: | Pandu Poluan <pandu(at)poluan(dot)info> |
|---|---|
| To: | Basil Bourque <basil(dot)list(at)me(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: How to add description for databases and tables? |
| Date: | 2011-12-07 09:18:17 |
| Message-ID: | CAA2qdGXwNn3=xS0g1v8nKJj89qut2_OyxsNAni_pQQC=7Rw0dg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Wed, Dec 7, 2011 at 14:50, Basil Bourque <basil(dot)list(at)me(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ioannis Anagnostopoulos | 2011-12-07 09:24:38 | Re: Linux server connection process consumes all memory |
| Previous Message | Basil Bourque | 2011-12-07 07:50:45 | Re: How to add description for databases and tables? |