Skip to main content

​
Browsing the Postgres DB via psql

psql is a cli tool to interact with a posgres db.

​
Installation (debian)

sudo apt install -y postgresql-common
sudo /usr/share/postgresql-common/pgdg/apt.postgresql.org.sh
sudo apt-get install postgresql-client-16

​
Connecting to the db

psql -p 5332 -h localhost demos demosuser

# psql -p <db_port> -h <db_host> <db_name> <db_user>
Enter the demosuser password as demospassword and hit enter.
credentials are defined at: postgres/docker-compose.yml in the node repo.
You can now list available tables using dt to get started. 
demos-# dt
               List of relations
 Schema |       Name        | Type  |   Owner   
--------+-------------------+-------+-----------
 public | blocks            | table | demosuser
 public | consensus         | table | demosuser
 public | mempool           | table | demosuser
 public | pgp_key_server    | table | demosuser
 public | status_hashes     | table | demosuser
 public | status_native     | table | demosuser
 public | status_properties | table | demosuser
 public | transactions      | table | demosuser
 public | validators        | table | demosuser
(9 rows)
Have fun!