SSH into a running PostgreSQL container - cardano-db-sync & cardano-graphql
From an already running container cardano-graphql run the following commands:
(Note: please see cardano-graphql repository for details on how to run cardano-graphql here
- ~/cardano-graphql$ docker ps
- docker exec -it $container_name /bin/bash
- bash-5.0# psql -U postgres -d cexplorer
- cexplorer=# \ dt
List of relations
Schema | Name | Type | Owner
--------+----------------------+-------+----------
public | block | table | postgres
public | delegation | table | postgres
public | epoch | table | postgres
public | epoch_param | table | postgres
public | epoch_stake | table | postgres
public | ma_tx_mint | table | postgres
- cexplorer=# select * from delegation;