Tag Archives: PostgreSQL

PostgreSQL: Show Column Values Vertically retrieved by SELECT SQL


Here, I introduce the way to show values vertically which are retrieved by SELECT SQL in PostgreSQL.

Continue reading PostgreSQL: Show Column Values Vertically retrieved by SELECT SQL

PostgreSQL: How to Get Current Year, Month, Day, Hour, Minute and Second


Here is the way to get current year, month, day, hour, minute and second in PostgreSQL.

Continue reading PostgreSQL: How to Get Current Year, Month, Day, Hour, Minute and Second

How to Access to PostgreSQL in VirtualBox Guest OS from Host OS


Here’s a tips to connect PostgreSQL in VirtualBox guest OS, from host OS. Host OS can be Windows and Mac, because this is change of PostgreSQL setting.

Continue reading How to Access to PostgreSQL in VirtualBox Guest OS from Host OS

PostgreSQL: Basic Cursor Handling


I summarized about cursor operation in PostgreSQL PL/pgSQL.

Continue reading PostgreSQL: Basic Cursor Handling