I will introduce the way to show database data on spread sheet of LibreOffice Calc, using LibreOffice Base. The data you retrieve from the database onto the spread sheet can be used for any table and pivot tables. I wrote the article “Excel: Retrieve and Show Database Data” before, which shows the way to get the data onto Excel through ODBC, but LibreOffice enables us to do the same thing for free.
Here is the way to get current year, month, day, hour, minute and second in PostgreSQL.
Here’s a tips to connect PostgreSQL in VirtualBox guest OS, from Windows. The article suppose host OS is Windows, but theoretically it is also the same way in other host OS.
I summarized about cursor operation in PostgreSQL PL/pgSQL.