Re: listing all tables without primary key

On Mon, May 16, 2005 at 05:43:58PM -0700, Jeff Frost wrote:
> Is there a simple way to list all tables without a primary key? Googling
> on this subject has not turned up any helpful sources thus far.

Here's what I've come up with:

SELECT
n.nspname AS "Schema",
c.relname AS "Table Name",
c.relhaspkey AS "Has PK"
FROM
pg_catalog.pg_class c
JOIN
pg_namespace n
ON (
c.relnamespace = n.oid
AND n.nspname NOT IN ('information_schema', 'pg_catalog')
AND c.relkind='r'
)
ORDER BY c.relhaspkey, c.relname
;

How would this work in the new system views?

Cheers,
D
--
David Fetter david(at)fetter(dot)org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778

Remember to vote!