Rip <rip(at)onlineinfo(dot)net> writes:
> I get correct results on a table for a.attnum, a.attname, t.typname,
> a.attlen, a.atttypmod, a.attnotnull and a.atthasdef, but for a view
> a.attnotnull and a.atthasdef return nothing.
What were you expecting? A view doesn't have constraints, nor default
values for columns.
regards, tom lane