PostgreSQL show query output in the pretty-format - psql command



This post shows how to show query output in the pretty-format using psql command:

Show query output in the pretty-format

Enter below psql command to show query output in the pretty-format:
\x
Example: Execute the below command to expand query result:
mydb=# \x
Expanded display is on.
mydb=# select * from users;
-[ RECORD 1 ]--------------
id       | 1
name     | Tony
email    | tony@gmail.com
country  | US
password | secret
-[ RECORD 2 ]--------------
id       | 2
name     | Ramesh
email    | ramesh@gmail.com
country  | India
password | password123
-[ RECORD 3 ]--------------
id       | 3
name     | John
email    | john@gmail.com
country  | US
password | password123
Execute "\x" command to disable expand like:
mydb=# \x
Expanded display is off.
mydb=# select * from users;
 id |  name  |      email       | country |  password
----+--------+------------------+---------+-------------
  1 | Tony   | tony@gmail.com   | US      | secret
  2 | Ramesh | ramesh@gmail.com | India   | password123
  3 | John   | john@gmail.com   | US      | password123
(3 rows)

Comments