postgres see schema code example

Example 1: show all Schemas postgres

\dn
# list the schemas

Example 2: check schema exists postgresql

SELECT schema_name FROM information_schema.schemata WHERE schema_name = 'name';