will trillich <will(at)serensoft(dot)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