Difference between revisions of "List schemas: \dn"

From wikieduonline
Jump to navigation Jump to search
Line 7: Line 7:
 
  [[public]] | [[postgres]]
 
  [[public]] | [[postgres]]
 
  (1 row)
 
  (1 row)
 +
 +
postgres=# \dn+
 +
                          List of schemas
 +
  Name  |  Owner  |  Access privileges  |      Description
 +
--------+----------+----------------------+------------------------
 +
  public | postgres | postgres=UC/postgres+| standard public schema
 +
        |          | =UC/postgres        |
 +
(1 row)
 +
  
 
  \dn
 
  \dn

Revision as of 09:28, 28 April 2022

Default Schema in Ubuntu

\dn
 List of schemas
 Name  |  Owner
--------+----------
public | postgres
(1 row)
postgres=# \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: