Difference between revisions of "PostgreSQL: \list"
Jump to navigation
Jump to search
| (20 intermediate revisions by 5 users not shown) | |||
| Line 1: | Line 1: | ||
List all [[databases]] | List all [[databases]] | ||
| − | |||
* https://www.postgresql.org/docs/13/app-psql.html | * https://www.postgresql.org/docs/13/app-psql.html | ||
Examples: | Examples: | ||
* <code>\l</code> | * <code>\l</code> | ||
| + | * <code>[[\l+]]</code> | ||
* <code>\list</code> | * <code>\list</code> | ||
| + | * <code>[[\list+]]</code> | ||
| + | * <code>\list your-db-beggining-with*</code> | ||
* <code>-l</code> | * <code>-l</code> | ||
* <code>--list</code> | * <code>--list</code> | ||
| + | |||
| + | == Examples == | ||
| + | |||
| + | [[PostgreSQL 16]] (Sep 2023) | ||
| + | List of databases | ||
| + | Name | Owner | Encoding | Locale Provider | Collate | Ctype | [[ICU Locale]] | [[ICU Rules]] | Access privileges | ||
| + | -----------+-------+----------+-----------------+---------+-------+------------+-----------+------------------- | ||
| + | postgres | user | UTF8 | [[libc]] | C | C | | | | ||
| + | [[template0]] | user | UTF8 | libc | C | C | | | =c/user + | ||
| + | | | | | | | | | user=CTc/user | ||
| + | template1 | user | UTF8 | libc | C | C | | | =c/user + | ||
| + | | | | | | | | | user=CTc/user | ||
| + | your-db | user | UTF8 | libc | C | C | | | | ||
| + | (4 rows) | ||
| + | |||
| + | |||
| + | |||
postgres-> \list | postgres-> \list | ||
List of databases | List of databases | ||
| − | Name | Owner | [[Encoding]] | [[Collate]] | [[Ctype]] | Access privileges | + | Name | Owner | [[Encoding]] | [[Collate]] | [[Ctype]] | [[Access privileges]] |
-----------+------------+----------+-------------+-------------+------------------------------- | -----------+------------+----------+-------------+-------------+------------------------------- | ||
YOUR_DB | [[rds_master]] | [[UTF8]] | en_US.UTF-8 | en_US.UTF-8 | =Tc/rds_master + | YOUR_DB | [[rds_master]] | [[UTF8]] | en_US.UTF-8 | en_US.UTF-8 | =Tc/rds_master + | ||
| Line 23: | Line 42: | ||
(4 rows) | (4 rows) | ||
| + | completePostgresql=> \list | ||
| + | List of databases | ||
| + | Name | Owner | Encoding | Collate | Ctype | Access privileges | ||
| + | --------------------+---------------------+----------+-------------+-------------+--------------------------------------------- | ||
| + | completePostgresql | complete_postgresql | UTF8 | en_US.UTF-8 | en_US.UTF-8 | | ||
| + | postgres | complete_postgresql | UTF8 | en_US.UTF-8 | en_US.UTF-8 | | ||
| + | rdsadmin | rdsadmin | UTF8 | en_US.UTF-8 | en_US.UTF-8 | rdsadmin=CTc/rdsadmin + | ||
| + | | | | | | rdstopmgr=Tc/rdsadmin | ||
| + | [[template0]] | rdsadmin | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/rdsadmin + | ||
| + | | | | | | rdsadmin=CTc/rdsadmin | ||
| + | [[template1]] | complete_postgresql | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/complete_postgresql + | ||
| + | | | | | | complete_postgresql=CTc/complete_postgresql | ||
| + | (5 rows) | ||
| − | + | == Related terms == | |
| − | ==Related terms== | ||
* [[List users]]: <code>[[\du]]</code> | * [[List users]]: <code>[[\du]]</code> | ||
| + | * [[List tables]]: <code>[[\dt]]</code> or <code>\dt *.*</code> | ||
* <code>[[\c]] YourDBName</code> | * <code>[[\c]] YourDBName</code> | ||
* <code>[[\z]] YourTable</code> | * <code>[[\z]] YourTable</code> | ||
| + | * <code>[[DROP DATABASE]]</code> | ||
| + | * <code>[[CREATE DATABASE]]</code> | ||
| + | * [[PostgreSQL Privileges]] | ||
| + | * <code>[[\connect]]</code> | ||
==See also== | ==See also== | ||
| + | * {{PostgreSQL Privileges}} | ||
* {{SQL}} | * {{SQL}} | ||
| − | |||
[[Category:PostgreSQL]] | [[Category:PostgreSQL]] | ||
Latest revision as of 17:38, 8 January 2024
List all databases
Examples:
Examples[edit]
PostgreSQL 16 (Sep 2023) List of databases Name | Owner | Encoding | Locale Provider | Collate | Ctype | ICU Locale | ICU Rules | Access privileges -----------+-------+----------+-----------------+---------+-------+------------+-----------+------------------- postgres | user | UTF8 | libc | C | C | | | template0 | user | UTF8 | libc | C | C | | | =c/user + | | | | | | | | user=CTc/user template1 | user | UTF8 | libc | C | C | | | =c/user + | | | | | | | | user=CTc/user your-db | user | UTF8 | libc | C | C | | | (4 rows)
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)
completePostgresql=> \list
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
--------------------+---------------------+----------+-------------+-------------+---------------------------------------------
completePostgresql | complete_postgresql | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
postgres | complete_postgresql | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
rdsadmin | rdsadmin | UTF8 | en_US.UTF-8 | en_US.UTF-8 | rdsadmin=CTc/rdsadmin +
| | | | | rdstopmgr=Tc/rdsadmin
template0 | rdsadmin | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/rdsadmin +
| | | | | rdsadmin=CTc/rdsadmin
template1 | complete_postgresql | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/complete_postgresql +
| | | | | complete_postgresql=CTc/complete_postgresql
(5 rows)
Related terms[edit]
- List users:
\du - List tables:
\dtor\dt *.* \c YourDBName\z YourTableDROP DATABASECREATE DATABASE- PostgreSQL Privileges
\connect
See also[edit]
- PostgreSQL Privileges, GRANT,
\list+, \du+ - SQL, NewSQL: GraphQL (2015), SQLite,
select, insert,select count, Distributed SQL, TablePlus, Cache hit ratio,pg_stat_user_tables,EXPLAIN, Index (PostgreSQL), DDL, SQL/MED, Group by, List users, SQL Injection, SQLAlchemy,CREATE USER, CREATE ROLE, EXPLAIN, ALTER DATABASE, REVOKE, NOLOCK, NOWAIT, EXISTS, Unique constraint
Advertising:
