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.

Environment

  • PostgreSQL 9.3

How to do

Execute \x command, then the column values are shown vertically, which is retrieved by SELECT query.

\x command

\? command shows the description of \x command. It is explained as toggle expanded output. Showing vertically is represented as Expand output.