top of page
Shareware software
The root node, contains the object type nodes in the PostgreSQL database. Object types are grouped by schemas. The name of the database is displayed in brackets.

SELECT n.oid, n.nspname AS "schema_name"
FROM pg_catalog.pg_namespace n
WHERE n.nspname not in ('information_schema','pg_catalog')
ORDER BY 2
bottom of page