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) Tom Lane <tgl@sss.pgh.pa.us>
Re: hot to determine calculated fields (views) will trillich <will@serensoft.com>
will trillich  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
Дата:
От: Bruno Wolff III
Дата:
Сообщение: overloaded function question
FAQ