On 08/14/12 7:18 AM, Dmitriy Igrishin wrote:
Hey all,

Is there way to determine a table column referenced by
a view column via SQL?

I want to create an universal function to determine
mandatoriness of some column of the view (i.e.
check the not null constraint of underlying table column).


note that a view column can be the result of a function or operation, perhaps on fields of several columns from several tables being joined in the view. how would your function cope with something like this?




--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to