Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group