Re: The comment of Primary key

It's rumoured that Hiroshi Saito once said:

> ----------------------------------------------------------------
> saito=# SELECT cls.oid, cls.relname as idxname, indrelid, indkey,
> indisclustered, indisunique, indisprimary, n.nspname,
>       indnatts, tab.relname as tabname, indclass, description,
>       pg_get_expr(indpred, indrelid, true) as indconstraint, contype,
>       condeferrable, condeferred, amname
>  FROM pg_index idx
>  JOIN pg_class cls ON cls.oid=indexrelid
>  JOIN pg_class tab ON tab.oid=indrelid
>  JOIN pg_namespace n ON n.oid=tab.relnamespace
>  JOIN pg_am am ON am.oid=cls.relam
>  LEFT OUTER JOIN pg_description des ON (des.objoid=cls.oid AND
>  des.objsubid = 0) LEFT OUTER JOIN pg_constraint con ON
>  con.conrelid=indrelid AND conname=cls.relname
> WHERE cls.relname = 'MyTransaction_pkey';

Hi Hiroshi,

I don't have a system to test this on at the moment so I may have missed
something...
You are joining to pg_description using pg_class.oid. This will return the
comment for the table. Try joining to pg_constraint.oid so it uses the
pkey records oid.
Regards, Dave.