[GENERAL] Constraints of view attributes - Mailing list pgsql-general

From
Subject [GENERAL] Constraints of view attributes
Date
Msg-id 20170511212428.59073fe1@florenz
Whole thread Raw
Responses Re: [GENERAL] Constraints of view attributes
Re: [GENERAL] Constraints of view attributes
List pgsql-general
Hi,

create table t1 (f1 text not null);
create table t2 (f2 text);
create view v as (select t1.f1, t2.f2 from t1, t2);

Given v, How can a find out the t1.f1 has a not null constraint.
I can easily find this for t1 in the system catalog, but not for v.
I learned on IRC today that this should be somewhere in pg_rewrite but
where exactly and how do I get this information? Parse rewrite
query_tree? How?

--
Greg


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] How to recover my postgres database ?
Next
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] Constraints of view attributes