Re: primary keys

In article <4447021E23B(dot)9BA8KG(at)129(dot)180(dot)47(dot)120>,
Klint Gore <kg(at)kgb(dot)une(dot)edu(dot)au> wrote:

% works for me on version 8.1.3
%
% SELECT attname
% FROM pg_index
% JOIN pg_class ON (indrelid = pg_class.oid)
% JOIN pg_attribute ON (attrelid = pg_class.oid)
% WHERE indisprimary IS TRUE
% AND attnum = any(indkey)
% AND relname = $tablename;

This will work on 7.4, 8.0, or 8.1

SELECT attname
FROM pg_index
JOIN pg_class as c1 ON (indrelid = c1.oid)
JOIN pg_class as c2 ON (indexrelid = c2.oid)
JOIN pg_attribute ON (attrelid = c2.oid)
WHERE indisprimary
AND c1.relname = $tablename
;

No arrays are hurt by this query.
--

Patrick TJ McPhee
North York Canada
ptjm(at)interlog(dot)com