Re: "Hidden" field for each column

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Don Y <pgsql(at)DakotaCom(dot)Net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: "Hidden" field for each column
Date: 2006-04-12 20:50:59
Message-ID: 4297.1144875059@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Don Y <pgsql(at)DakotaCom(dot)Net> writes:
> I want to be able to embed in the database parameters
> that tell it how to interpret each column. In other
> words, while the TYPE for two columns might be
> text/char/varchar/etc., the data that each contained
> could have vastly different interpretations.

If I were you, I'd probably do that by creating a bunch of domains
and using the domains instead of plain text/etc as the column types.
See CREATE DOMAIN.

You could also commandeer the COMMENT ON COLUMN facility if you'd
rather have a text string associated with each column.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Nick Johnson 2006-04-12 20:53:17 pg_restore --schema always returns an empty dump
Previous Message Tom Lane 2006-04-12 20:45:13 Re: postmaster.pid