Re: How to add description for databases and tables?

From: Carlo Ascani <carlo(dot)ascani(at)2ndquadrant(dot)it>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: How to add description for databases and tables?
Date: 2011-12-06 08:25:29
Message-ID: 20111206092529.34836666@2ndquadrant.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Tue, 6 Dec 2011 14:57:43 +0700
Pandu Poluan <pandu(at)poluan(dot)info> wrote:

> Hello! I'm a PostgreSQL novice, and am currently learning PostgreSQL
> administration.
>
> 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

>
> TIA.
>
> Rgds,

--
Carlo Ascani - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
carlo(dot)ascani(at)2ndQuadrant(dot)it - www.2ndQuadrant.it

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Ioannis Anagnostopoulos 2011-12-06 09:14:23 Re: Linux server connection process consumes all memory
Previous Message Pandu Poluan 2011-12-06 07:57:43 How to add description for databases and tables?