Knowledge Bases
Docs
Dashboard
OCP
Freecad
CNC
LinkedIn
Page tree

Versions Compared

Old Version 1

changes.mady.by.user Adrian Stroila

Saved on

compared with

New Version Current

changes.mady.by.user Adrian Stroila

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Connect to Jira database

Code Block
[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

Code Block
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

Code Block
bash-4.3# psql -h localhost -U postgres jiradb
psql (9.5.4)
Type "help" for help.

jiradb=#