- 2005-10-10
- pgsql
メモ。だいだいこんなもんだろ。
SELECT n.nspname
, r.relname
FROM pg_class r
, pg_namespace n
WHERE r.relnamespace = n.oid
AND r.relkind = 'r'
AND n.nspname NOT IN ('information_schema', 'pg_catalog', 'pg_toast')
AND NOT EXISTS
(SELECT * FROM pg_constraint c
WHERE c.conrelid = r.oid
AND c.contype = 'p')