Search Postgresql Archives

Re: Need text wrapping inside a column to avoid record wrapping (tabular output of 'select')

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 2018-Jul-25, David Gauthier wrote:

> Hi:
> 
> psql (9.6.7, server 9.1.9)  on RHEL6
> 
> In order to avoid record wrapping in the tabular output of a "select"
> statement, I need to limit the width of certain columns.  For those
> columns, I would like to have text wrapping so as not to lose any
> information (IOW, I don't want to simply truncatate and lose info).

\pset format wrapped

It doesn't break on whitespace though.

 $ 999,00 │ Nine hundred ninety nine dollars and z…
          │…ero cents
 $ 1.000,…│ One thousand  dollars and zero cents
…      00 │ 

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux