BCA-Queries-Cardano

bach to main

Using pgAdmin

pgAdmin is available locally at http://localhost:5480

let’s write a simple “hello world” SQL query:

SELECT slot_no, "time" FROM public.block ORDER BY id DESC LIMIT 1;

(which outputs the slot number and block time of the latest block)

Querying the database in pgAdmin