Connect to Jira database
[root@atlassian-jira cloud-user]# docker exec -it postgresql bash bash-4.3# psql -h localhost -U postgres psql (9.5.4) Type "help" for help. postgres=#
List database
postgres=# \l List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges -----------+----------+----------+------------+------------+----------------------- jiradb | postgres | UTF8 | C | C | postgres | postgres | UTF8 | en_US.utf8 | en_US.utf8 | template0 | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =c/postgres + | | | | | postgres=CTc/postgres template1 | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =c/postgres + | | | | | postgres=CTc/postgres (4 rows)
Select DB
bash-4.3# psql -h localhost -U postgres jiradb psql (9.5.4) Type "help" for help. jiradb=#