Skip to end of metadata
Go to start of metadata

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=# 



  • No labels