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,