top of page
Волнистый абстрактный фон
CerebroSQL

OBJECT node for PostgreSQL

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. 

List schema for PostgreSQL

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