Re: Can a function determine whether a primary key constraint exists on a table? - Mailing list pgsql-general

In article <52EF20B2E3209443BC37736D00C3C1380AD5FEFF@EXADV1.host.magwien.gv.at>,
Albe Laurenz <all@adv.magwien.gv.at> wrote:

% >                                     How can I check for the
% > presence of constraints inside a function?
%
% select t.oid as tableid, t.relname as tablename,
%       c.oid as constraintid, conname as constraintname
% from pg_constraint c join pg_class t on (c.conrelid = t.oid);

or, perhaps simpler,

 select * from information_schema.table_constraints
  where constraint_type = 'PRIMARY KEY';

--

Patrick TJ McPhee
North York  Canada
ptjm@interlog.com