Get additional constraint information

From: "Tobias Fielitz" <tobias(at)dealsta(dot)com(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: Get additional constraint information
Date: 2015-08-04 01:55:34
Message-ID: 1438653333985.cde770c5@Nodemailer
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 FielitzCTO StreetHawk
+61404267511
tobias.fielitz (skype)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message William Dunn 2015-08-04 04:24:07 Re: Transaction ID Wraparound Monitoring
Previous Message Raymond O'Donnell 2015-08-03 15:43:51 Re: pghba.conf