Difference between revisions of "List schemas: \dn"
Jump to navigation
Jump to search
| Line 38: | Line 38: | ||
* [[SELECT version();]] | * [[SELECT version();]] | ||
* [[CREATE SCHEMA]] | * [[CREATE SCHEMA]] | ||
| − | * [[GRANT]] | + | * [[GRANT]], [[GRANT ALL]] |
== See also == | == See also == | ||
Revision as of 14:33, 28 April 2022
Default Schema in 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
See also
Advertising:
