Re: Column descriptions - could they be propagated to new tables?

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "Clive Page" <cgp(at)star(dot)le(dot)ac(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Column descriptions - could they be propagated to new tables?
Date: 2006-04-05 16:15:07
Message-ID: b42b73150604050915k1427caeeq1e07de94e0841397@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 4/5/06, Clive Page <cgp(at)star(dot)le(dot)ac(dot)uk> wrote:
> Since I discovered the facilities in Postgres for providing and listing
> column descrptions, I have found them very useful, especially for adding a
> string showing physical units to my columns.

Have you considered using domains for these types? You can comment
the domain appropriately. While the domain description will not show
in \d+. to get the description you can do \dT on the domain.

Based on your background I also think you might appreciate domains
from a design perspective. There are a couple of disadvantages to
using them so I'd suggest reading about them.

merlin

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Neil Conway 2006-04-05 16:19:16 Re: Oracle outer join syntax
Previous Message Tom Lane 2006-04-05 16:13:00 Re: Oracle outer join syntax