I like to use Datagrip.

Get psql: nix-shell -p postgresql_15 Find the path for Datagrip: which psql I use the GUI to restore: