Re: hot to determine calculated fields (views) - Mailing list pgsql-general

From Tom Lane
Subject Re: hot to determine calculated fields (views)
Date
Msg-id 11134.1043513442@sss.pgh.pa.us
Whole thread Raw
In response to hot to determine calculated fields (views)  (will trillich <will@serensoft.com>)
Responses Re: hot to determine calculated fields (views)
List 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 by date:

Previous
From: Tilo Schwarz
Date:
Subject: Documentation improvement suggestions
Next
From: Bruno Wolff III
Date:
Subject: overloaded function question