Tag Archives: [:ja]データベース[:en]Database[:]

Make PostgreSQL Accessible from Outside


I will introduce how to make PostgreSQL accessible from outside clilent. ホストOSから VirtualBox の中の PostgreSQL にアクセスする方法 の内容と重複する部分があります。

Continue reading Make PostgreSQL Accessible from Outside

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

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

Windows, Excel: Connect Database Directly and Show the Data


Here, I introduce the way to show the database records in Excel directly. In this article, I’ll show you the way using ODBC connection. (There are other ways.)

Continue reading Windows, Excel: Connect Database Directly and Show the Data

PostgreSQL: How to Export SQL Result to File


I will introduce you several way to output sql result into a file with using psql.

Continue reading PostgreSQL: How to Export SQL Result to File