Re: "Hidden" field for each column - Mailing list pgsql-general

From Tom Lane
Subject Re: "Hidden" field for each column
Date
Msg-id 4297.1144875059@sss.pgh.pa.us
Whole thread Raw
In response to "Hidden" field for each column  (Don Y <pgsql@DakotaCom.Net>)
List pgsql-general
Don Y <pgsql@DakotaCom.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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: postmaster.pid
Next
From: Nick Johnson
Date:
Subject: pg_restore --schema always returns an empty dump