Lesezeichen

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


Beschreibung

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;

Vorschau

Tags

Nutzer

  • @flimm

Kommentare und Rezensionen