List schemas: \dn

Default Schemas in PostgreSQL Ubuntu

\dn
 List of schemas
 Name  |  Owner
--------+----------
public | postgres
(1 row)

select nspname as schema, usename as owner from pg_namespace, pg_user where pg_namespace.nspowner = pg_user.usesysid and pg_user.usename ='YOUR_USERNAME';

\dn+
                          List of schemas
  Name  |  Owner   |  Access privileges   |      Description
--------+----------+----------------------+------------------------
 public | postgres | postgres=UC/postgres+| standard public schema
        |          | =UC/postgres         |
(1 row)

\dn
         List of schemas
    Name     |       Owner
-------------+-------------------
 your_schema1   | your_username
 your_schema1      | your_username
 your_schema1       | your_username2
 your_schema1 | rds_master
 public      | rds_master
 raw         | rds_master
(6 rows)

Related

• SELECT version();
• CREATE SCHEMA
• GRANT, GRANT ALL, GRANT USAGE

See also

• Schema, search_path, \dn+, GRANT ALL PRIVILEGES ON SCHEMA, schema migration, Schemacrawler
• PostgreSQL: psql, .psqlrc, .pgpass, $HOME/.pg service.conf, -U, -W, -d, meta-commands: \du, \dg, \ddp, \dp, \list, \dn, \dt, \c, \l, \di, \q, show users, show, su - postgres, psql -c, \?, \connect, \conninfo, --version, --help, PL/pgSQL