/SQL/Postgres show databases

Postgres show databases

Postgresql show current database

SELECT current_database();

4

Postgres show databases

# inside psql
\l

1

Psql show db

SELECT datname FROM pg_database;
Code language: SQL (Structured Query Language) (sql)

0

Source: postgresqltutorial.com

Similar codes

0 vote176 views1 answer
How to change mysql root password in windows 10
SQL
0 vote172 views1 answer
Ms sql filter all sympbol
SQL
1 vote170 views1 answer
Where database run
SQL
22 votes279 views4 answers
Tsql rename table
SQL
0 vote173 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
0 vote186 views1 answer
Dual in db2
SQL
12 votes160 views3 answers
Duplicate a column in sql
SQL
9 votes186 views4 answers
Last mysql
SQL
1 vote163 views1 answer
Oracle get current schema
SQL
0 vote161 views1 answer
Codeigniter 3 get best-selling products
SQL

Share