CREATE TABLE boo.author
(
  id serial NOT NULL,
  "login" varchar( 8 ) NOT NULL,
  "password" varchar( 40 ) NOT NULL,
  name varchar( 30 ) NOT NULL,
  CONSTRAINT author_pkey PRIMARY KEY (id)
) 
WITHOUT OIDS;
ALTER TABLE boo.author OWNER TO postgres;

        SELECT pg_index.indisprimary,
            pg_catalog.pg_get_indexdef(pg_index.indexrelid)
        FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,
            pg_catalog.pg_index AS pg_index
        WHERE c.relname = 'boo.author'
            AND c.oid = pg_index.indrelid
            AND pg_index.indexrelid = c2.oid
            AND pg_index.indisprimary

SELECT 
pg_index.indisprimary,
pg_indexes.indexdef,
pg_indexes.schemaname
FROM pg_catalog.pg_class c, pg_catalog.pg_class c2, pg_catalog.pg_index AS pg_index, pg_indexes
WHERE c.relname = 'author'
AND c.oid = pg_index.indrelid
AND pg_index.indexrelid = c2.oid
AND pg_index.indisprimary
AND pg_indexes.tablename = 'author'
AND pg_indexes.schemaname = 'boo'
AND pg_catalog.pg_get_indexdef(pg_index.indexrelid) = pg_indexes.indexdef;