---
title: "Discussion on \"How to turn on the expanded table formatting mode in PostgreSQL\" | Hashnode"
description: "Discussion on \"How to turn on the expanded table formatting mode in PostgreSQL\". Note: The following was tested with PostgreSQL 13.1\nDefault setting: \\x off\n$ psql myblog_dev\n\nmyblog_dev=# SELECT \"users\".* FROM \"users\" WHERE \"users\".\"role\" = 10 LIMIT 1;\n\nThe output format would be:\n\nIt was difficult to read the result.\nTurn on th..."
url: "https://hashnode.com/posts/how-to-turn-on-the-expanded-table-formatting-mode-in-postgresql/65c47fcd8fb82939a6abc1b4"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [How to turn on the expanded table formatting mode in PostgreSQL](https://lynnbright.com/how-to-turn-on-the-expanded-table-formatting-mode-in-postgresql?utm_source=hashnode&utm_medium=feed)

Note: The following was tested with PostgreSQL 13.1 Default setting: \\x off $ psql myblog\_dev myblog\_dev=# SELECT "users".\* FROM "users" WHERE "users"."role" = 10 LIMIT 1; The output format would be: It was difficult to read the result. Turn on th...

Dec 1, 2021 · 2 min read · lynnbright.com  
Read the article

-   [#postgresql](https://hashnode.com/tag/postgresql)

## Written by

[Lynn Chang](https://hashnode.com/@Lynnbright)

@Lynnbright · Taipei, Taiwan

  
[View profile](https://hashnode.com/@Lynnbright)

Rails Developer

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
