My main use case for PostgreSQL on Ubuntu is to query the database and the tables.
A quick specific example of a task where I used PostgreSQL on Ubuntu to query the database or tables is that I query the tables with SQL code, and it is very smart. I do feature engineering directly in SQL.