Difference between revisions of "List schemas: \dn"

From wikieduonline
Jump to navigation Jump to search
 
(8 intermediate revisions by 3 users not shown)
Line 1: Line 1:
  
Default Schema in Ubuntu
+
Default [[Schema]]s in PostgreSQL Ubuntu
 
  \dn
 
  \dn
 
   List of schemas
 
   List of schemas
Line 9: Line 9:
  
  
  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';
+
  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';
  
  
Line 36: Line 36:
  
 
== Related ==
 
== Related ==
* [[SELECT version();]]
+
* <code>[[SELECT version();]]</code>
* [[CREATE SCHEMA]]
+
* <code>[[CREATE SCHEMA]]</code>
* [[GRANT]]
+
* <code>[[GRANT]]</code>, <code>[[GRANT ALL]]</code>, <code>[[GRANT USAGE]]</code>
  
 
== See also ==
 
== See also ==
 +
* {{Schema}}
 
* {{psql}}
 
* {{psql}}
  
 
[[Category: PostgreSQL]]
 
[[Category: PostgreSQL]]
 
[[Category: SQL]]
 
[[Category: SQL]]

Latest revision as of 12:07, 11 May 2023

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[edit]

See also[edit]

Advertising: