Aqua Data Studio
Register New Server
Toolbar menu:
Server -> Register Server
Or right-click on a Server Group.
In the Register Server window (or Edit Server window):
Select the type of server
Give the connection a name
Enter credentials
Enter host, port, database name
Click “Test Connection” to confirm the connection works.
Save
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.NonValidatingFactory
Summarize all loans from each location by patron group
select li.location_name, g.groupname, count(*)
from loans_item li
join loans l on li.loan_id = l.id
join users u on l.user_id = u.id
join groups g on u.patron_group_id = g.id
group by li.location_name, g.groupname
order by li.location_name, g.groupname
;
Export Results
Results can be saved to a variety of formats. From menu bar:
File -> Save Results
Then you can save in different data formats such as delimited text, HTML, XML, Excel, etc.:
Note that the results will need to fit into memory. This will not be suitable for a very large result set.
For large results, one might try generating and modifying and AquaScript. This is a JavaScript-like language (extension?) for ADS. I have not investigated, it is possible it has the features for spooling a large result set without accumulating it all in memory.