postgres-tables-without-unique-keys.sql

SELECT
      n.nspname
    , c.relname
    , c.relhaspkey
		, sum(case when i.indisunique = 't' then 1 else 0 end)
FROM
    pg_catalog.pg_class c
INNER
		JOIN pg_namespace n
		ON c.relnamespace = n.oid
    AND n.nspname NOT IN ('information_schema', 'pg_catalog')
    AND c.relkind='r'
LEFT OUTER
	JOIN pg_index i on c.oid = i.indrelid
WHERE
	c.relhaspkey = 'f'
group BY
	n.nspname
	    ,c.relname
	    ,c.relhaspkey
having sum(case when i.indisunique = 't' then 1 else 0 end) = 0
ORDER BY c.relhaspkey, c.relname