Re: "Hidden" field for each column

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: "Hidden" field for each column
Дата
Msg-id 4297.1144875059@sss.pgh.pa.us
обсуждение исходный текст
Ответ на "Hidden" field for each column  (Don Y <pgsql@DakotaCom.Net>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: postmaster.pid
Следующее
От: Nick Johnson
Дата:
Сообщение: pg_restore --schema always returns an empty dump