Difference between revisions of "PostgreSQL: \list"

From wikieduonline
Jump to navigation Jump to search
Tags: Mobile web edit, Mobile edit
Tags: Mobile web edit, Mobile edit
Line 7: Line 7:
 
* <code>-l</code>
 
* <code>-l</code>
 
* <code>--list</code>
 
* <code>--list</code>
 +
 +
 +
postgres-> \list
 +
                                        List of databases
 +
    Name    |  Owner    | [[Encoding]] |  [[Collate]]  |    [[Ctype]]    |      Access privileges
 +
-----------+------------+----------+-------------+-------------+-------------------------------
 +
  YOUR_DB | [[rds_master]] | [[UTF8]]    | en_US.UTF-8 | en_US.UTF-8 | =Tc/rds_master              +
 +
            |            |          |            |            | rds_master=CTc/rds_master 
 +
  rdsadmin  | rdsadmin  | UTF8    | en_US.UTF-8 | en_US.UTF-8 | rdsadmin=CTc/rdsadmin
 +
  template0 | rdsadmin  | UTF8    | en_US.UTF-8 | en_US.UTF-8 | =c/rdsadmin                  +
 +
            |            |          |            |            | rdsadmin=CTc/rdsadmin
 +
  template1 | rds_master | UTF8    | en_US.UTF-8 | en_US.UTF-8 | rds_master=CTc/rds_master    +
 +
            |            |          |            |            | =c/rds_master
 +
(4 rows)
 +
  
  

Revision as of 08:49, 9 September 2021

List all databases

  • \l
  • \list
  • -l
  • --list


postgres-> \list
                                       List of databases
   Name    |   Owner    | Encoding |   Collate   |    Ctype    |       Access privileges
-----------+------------+----------+-------------+-------------+-------------------------------
 YOUR_DB | rds_master | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/rds_master               +
           |            |          |             |             | rds_master=CTc/rds_master   
 rdsadmin  | rdsadmin   | UTF8     | en_US.UTF-8 | en_US.UTF-8 | rdsadmin=CTc/rdsadmin
 template0 | rdsadmin   | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/rdsadmin                  +
           |            |          |             |             | rdsadmin=CTc/rdsadmin
 template1 | rds_master | UTF8     | en_US.UTF-8 | en_US.UTF-8 | rds_master=CTc/rds_master    +
           |            |          |             |             | =c/rds_master
(4 rows)


Related terms

See also

Advertising: