bookmark

inheritance - How to find inherited tables programatically in PostgreSQL? - Stack Overflow


Description

SELECT pg_namespace.nspname, pg_class.relname FROM pg_catalog.pg_inherits INNER JOIN pg_catalog.pg_class ON (pg_inherits.inhrelid = pg_class.oid) INNER JOIN pg_catalog.pg_namespace ON (pg_class.relnamespace = pg_namespace.oid) WHERE inhparent = 'pp'::regclass;

Preview

Tags

Users

  • @flimm

Comments and Reviews