PostgreSQL Discussion - Re: Column descriptions - could they be propagated to new

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: Column descriptions - could they be propagated to new

Clive Page

2006-04-05, 1:37 pm

On Wed, 5 Apr 2006, Merlin Moncure wrote:

> 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.

Thanks for the suggestion, I'll start reading up on them.

--
Clive Page
Dept of Physics & Astronomy,
University of Leicester,
Leicester, LE1 7RH, U.K.

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Sponsored Links