DBA Hub

📋Steps in this guide1/1

Find the database details in postgres

postgres=# \list+ List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges | Size | Tablespace | Description -----------+----------+----------+---------+-------+-----------------------+---------+------------+-------------------------------------------- dbaclass | postgres | UTF8 | C | C | | 2268 MB | pg_default | postgres | postgres | UTF8 | C | C | | 4132 MB | pg_default |

postgresql configurationintermediate
by PostgreSQL
12 views
1

Find the database details in postgres

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
postgres=#
\list+
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges | Size | Tablespace | Description
-----------+----------+----------+---------+-------+-----------------------+---------+------------+--------------------------------------------
dbaclass | postgres | UTF8 | C | C | | 2268 MB | pg_default |
postgres | postgres | UTF8 | C | C | | 4132 MB | pg_default | default administrative connection database
template0 | postgres | UTF8 | C | C | =c/postgres +| 7601 kB | pg_default | unmodifiable empty database
| | | | | postgres=CTc/postgres | | |
template1 | postgres | UTF8 | C | C | =c/postgres +| 7601 kB | pg_default | default template for new databases
| | | | | postgres=CTc/postgres | | |
(4 rows)
postgres=#
select datname from pg_database;
datname
-----------
postgres
template1
template0
dbaclass
(4 rows)

Comments (0)

Please to add comments

No comments yet. Be the first to comment!