Hi...
Doing some automatic metadata parsing job against postgresql schema I
just find that database views always shown all its column as nullable, it
doesn't matter what are the constraints in the original table columns used
as source to create the view.
I just checked it against infomation_schema and pg_attribute with the same
result.
I'm aware that pg_attributes.attnotnull is updatable reflecting the changes
in information_schema also, but, do you know of some SQL query to extract
this information correctly automatically?
Regards,