I don't know postgresql but is it worse that sqlite? MS Access on the other hand is easy!
It's a different sort of beast than SQLite/Access.
SQLite, Access, and FirebirdDB in 'local' mode are examples of 'file based databases' (Access of course is normally used via the application, but you can absolutely get to it in other ways.)
Postgres, MySQL/MariaDB, Microsoft SQL Server (MSSQL), Oracle, and FirebirdDB in 'client/server' mode, involve having a dedicated server (or cluster of servers) that store the data and run the actual SQL logic.
Hope that helps?
I meant in reference to Crosstab query, not the databases themselves.