Disable wrapping in Psql output

Question

When using Psql in Linux, if the result of my SQL query contains many columns or long strings of data, it will wrap the initial view and only once I scroll to the side will it stop wrapping and show each row on a separate line.

I've tried various \pset options such as format unaligned, format aligned, format wrapped, columns 0, columns 1000, but none seemed to fully stop wrapping unless I generate static output to a file.

How can I set it to never wrap the output while still being scrollable and showing the result using the default ascii table format?

Checkout pspg, a pager specifically designed for PostgreSQL use. — chb
– chb, Commented Aug 31, 2020 at 6:39

Cirelli94 · Accepted Answer · 2022-11-16 11:31:54Z

101

Psql uses a system viewer to show its output in the console. In bash it likely uses less for the scrollable/page-able features it provides. To use a different viewer or use different settings, you just need to set the PAGER environment variable.

Running psql to use less with the -S or --chop-long-lines option seemed to work for me:

PAGER="less -S" psql

You can also toggle this feature while viewing output in less by typing -S and Enter.

edited Nov 16, 2022 at 11:31

Cirelli94

1,9031 gold badge16 silver badges26 bronze badges

answered Oct 4, 2016 at 11:15

Silveri

5,4414 gold badges42 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ciro Santilli OurBigBook.com Over a year ago

psql() ( PAGER="less -S" command psql "$@" )

Shayan Over a year ago

My PSQL version uses less -S by default it seems, is there anyway to turn on wrapping without turning off pager?

Akshay Shet · Accepted Answer · 2017-04-05 07:12:42Z

29

To disable the wrapped output of the select query.

\pset pager on and \pset pager off to switch back to the older output view.

answered Apr 5, 2017 at 7:12

Akshay Shet

4414 silver badges7 bronze badges

1 Comment

AndrewHarvey Over a year ago

This turns off the pager completely, preventing scrolling up and down through large datasets (it will try to print the whole output to the terminal). Using @Silveri's tip still lets you use the pager for scrolling but just prevents wrapping.

gilad905 · Accepted Answer · 2024-01-05 10:49:49Z

26

The default pager for psql is less. Then for no wrapped lines must be use less -S. PAGER="less -S" psql is a good aproach. But inside psql you can use

\setenv PAGER 'less -S'

Then, to toggle it off and back on, use

\pset pager off
\pset pager on

edited Jan 5, 2024 at 10:49

gilad905

3,2373 gold badges20 silver badges25 bronze badges

answered Dec 24, 2020 at 15:09

Alejandro Salamanca Mazuelo

1,41119 silver badges24 bronze badges

Comments

Eric Leschinski · Accepted Answer · 2017-09-22 00:49:16Z

15

less's -F or -S flag will causes \d some_table to not show any output in some cases.

-F or --quit-if-one-screen
    Causes less to automatically exit if the entire file can be 
    displayed on the first screen.

-S or --chop-long-lines
    Causes lines longer than the screen width to be chopped rather than folded. 
    That is, the portion of a long line that does not fit in the screen width is 
    not shown. The default is to fold long lines; that is, display the remainder 
    on the next line.

Use them like this:

PAGER="less -S" psql

Seems safer at the inconvenience of having to manually exit less.

edited Sep 22, 2017 at 0:49

Eric Leschinski

155k96 gold badges423 silver badges337 bronze badges

answered Sep 21, 2017 at 18:21

Arian Daneshvar

1511 silver badge3 bronze badges

1 Comment

qwertzguy Over a year ago

Thanks! Simply typing -S then enter will disable line wrap while looking at psql query output

Eugen Konkov · Accepted Answer · 2017-12-06 11:05:02Z

10

probably you should use aligned format for output:

\pset format aligned

You can check all available formats to fit your needs:

\pset format TAB
aligned          html             latex-longtable  unaligned        
asciidoc         latex            troff-ms         wrapped

Also you should check PAGER configured value in your environment

answered Dec 6, 2017 at 11:05

Eugen Konkov

26k17 gold badges128 silver badges190 bronze badges

3 Comments

ash Over a year ago

aligned inserts the results into an ASCII-art table for me, which for long values means that I get many lines of ----- to create the table header before the actual values. unaligned avoids this.

alinsoar Over a year ago

for me it was better with \pset format wrapped.

SamGoody Over a year ago

you could add -t and it will skip the table headers. And -q to skip some of the other headers.

Collectives™ on Stack Overflow

Disable wrapping in Psql output

5 Answers 5

2 Comments

1 Comment

Comments

1 Comment

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

1 Comment

Comments

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related