Re: hot to determine calculated fields (views)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: hot to determine calculated fields (views)
Дата
Msg-id 11134.1043513442@sss.pgh.pa.us
обсуждение исходный текст
Ответ на hot to determine calculated fields (views)  (will trillich <will@serensoft.com>)
Ответы Re: hot to determine calculated fields (views)  (will trillich <will@serensoft.com>)
Список pgsql-general
will trillich <will@serensoft.com> writes:
> how can i tell whether i'm looking at a computed field (from a
> view) as opposed to actual data (brought in directly from a
> table)? something in pg_attribute, i hope... :)

You mean, how to tell which columns of a view are just "select foo from..."
and which are more complex expressions?

AFAICS, the only way is to parse the view definition rule.  The system
won't give you any help on this, because it neither knows nor cares...

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Tilo Schwarz
Дата:
Сообщение: Documentation improvement suggestions
Следующее
От: Bruno Wolff III
Дата:
Сообщение: overloaded function question