In article <[EMAIL PROTECTED]>, Klint Gore <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings