Aqua Data Studio
Register New Server
Toolbar menu:
...
Click “Test Connection” to confirm the connection works.
Save
Sample queries
...
Configuring SSL
The Aqua Data Studio documentation on SSL Configuration covers configuration of SSL including installing certificates.
A simpler alternative, for non-production testing purposes, is to use a "NonValidatingFactory". In summary, under Server Properties > Driver, use the parameter:
?ssl=true;sslfactory=org.postgresql.ssl.NonValidatingFactorySummarize all loans from each location by patron group
...
select li.location_name, g.groupname, count(*)
...
order by li.location_name, g.groupname
;
Export Results
Results can be saved to a variety of formats. From menu bar:
...