Sorry, this entry is only available in Japanese.
Install procedure of PostgreSQL for Windows, in Jan 2018.
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.