Re: [GENERAL] Get additional constraint information

[Igor Neyman]

From: pgsql-general-ow...@postgresql.org 
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Tobias Fielitz
Sent: Monday, August 03, 2015 9:56 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Get additional constraint information

select * from information_schema.table_constraints where
table_name=‘install_crash’;

Results here: http://imgur.com/YymSvBS

How can I get more information about these constraints, especially on which 
columns the not null constraints are?

Thanks

Tobias Fielitz
CTO StreetHawk
+61404267511
tobias.fielitz (skype)

--

select column_name, is_nullable from information_schema.columns where 
table_name = 'install_crash';

Regards,
Igor Neyman