Difference between revisions of "Show databases"
Jump to navigation
Jump to search
| Line 36: | Line 36: | ||
== See also == | == See also == | ||
| − | |||
| − | |||
| − | |||
* {{SQL}} | * {{SQL}} | ||
* {{DBs}} | * {{DBs}} | ||
[[Category:PostgreSQL]] | [[Category:PostgreSQL]] | ||
Revision as of 14:51, 18 November 2022
\list
SELECT datname FROM pg_database WHERE datistemplate = false; datname ---------- postgres (1 row)
SELECT datname FROM pg_database WHERE datistemplate = false; datname ---------- postgres your_database_name (2 rows)
rs0:PRIMARY> show databases; admin 0.031GB config 0.031GB local 0.281GB YOUR_NAME 2.499GB
Related terms
- Connect to a database
- Show databases
- Create database
- Delete database
- Create user
- List users
- List databases
- List tables:
show tables - GRANT
- PostgreSQL:
connect to MY_DATABASE_NAME - Show (MariaDB)
See also
- 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 - Databases: Database management, SQL, NoSQL, Wide column, PostgreSQL, MariaDB, MySQL, Derby DB, MongoDB, Cassandra, SQLite, HSQL2, H2, RocksDB, Microsoft SQL Server, DB2, Oracle Database, Memcached, Berkeley DB, Collation, SingleStore, Amazon Aurora, Graph database, Amazon DynamoDB, PrestoDB, Cache hit ratio, ACID, WAL, ARIES, DBMS, OLTP, OLAP, Database Schema, CockroachDB, Tables, Views, Apache Druid
Advertising:
