Re: Get additional constraint information

Поиск
Список
Период
Сортировка
От Igor Neyman
Тема Re: Get additional constraint information
Дата
Msg-id A76B25F2823E954C9E45E32FA49D70ECCD50D1DC@mail.corp.perceptron.com
обсуждение исходный текст
Ответ на Get additional constraint information  ("Tobias Fielitz" <tobias@dealsta.com.au>)
Список pgsql-general

 

 

From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@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’;

 

 

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

 

В списке pgsql-general по дате отправления:

Предыдущее
От: clingareddy@vsoftcorp.com
Дата:
Сообщение: Bi-Directional replication(BDR)
Следующее
От: Brian Dunavant
Дата:
Сообщение: Re: Bi-Directional replication(BDR)