Re: expanded \df+ display broken in beta4 - Mailing list pgsql-hackers

Good point.  We modified 8.1 so backslash commands do not honor \x
because things like \d look silly in \x, but \df+ looks better with \x,
no question.

Ideally I think \x should allow three modes, on, off, and auto, with
auto doing \x if the row output is wider than the screen.  If we had
this, backslash commands could be auto, or we can set all queries to
auto by default.

Added to TODO:
       o Add auto-expanded mode so expanded output is used if the row         length is wider than the screen width.
         Consider using auto-expanded mode for backslash commands like \df+.


---------------------------------------------------------------------------

Robert Treat wrote:
> not sure exactly when this was changed, but expanded display of \df+
> output is broken in beta4. compare:
> 
> 
> [postgres@localhost data]$ /usr/local/pgsql-8.1.x/bin/psql -p 5481
> template1
> Welcome to psql 8.1beta4, the PostgreSQL interactive terminal.
> 
> Type:  \copyright for distribution terms
>        \h for help with SQL commands
>        \? for help with psql commands
>        \g or terminate with semicolon to execute query
>        \q to quit
> 
> template1=# \df+ area
>                                                    List of functions
>    Schema   | Name | Result data type | Argument data types |  Owner   |
> Language | Source code |      Description      
>
------------+------+------------------+---------------------+----------+----------+-------------+-----------------------
>  pg_catalog | area | double precision | box                 | postgres |
> internal | box_area    | box area
>  pg_catalog | area | double precision | circle              | postgres |
> internal | circle_area | area of circle
>  pg_catalog | area | double precision | path                | postgres |
> internal | path_area   | area of a closed path
> (3 rows)
> 
> template1=# \x 
> Expanded display is on.
> template1=# \df+ area
>                                                    List of functions
>    Schema   | Name | Result data type | Argument data types |  Owner   |
> Language | Source code |      Description      
>
------------+------+------------------+---------------------+----------+----------+-------------+-----------------------
>  pg_catalog | area | double precision | box                 | postgres |
> internal | box_area    | box area
>  pg_catalog | area | double precision | circle              | postgres |
> internal | circle_area | area of circle
>  pg_catalog | area | double precision | path                | postgres |
> internal | path_area   | area of a closed path
> 
> 
> [postgres@localhost data]$ /usr/local/pgsql-8.0.x/bin/psql -p 5481
> template1
> Welcome to psql 8.0.4, the PostgreSQL interactive terminal.
> 
> Type:  \copyright for distribution terms
>        \h for help with SQL commands
>        \? for help with psql commands
>        \g or terminate with semicolon to execute query
>        \q to quit
> 
> template1=# \df+ area
>                                                    List of functions
>    Schema   | Name | Result data type | Argument data types |  Owner   |
> Language | Source code |      Description      
>
------------+------+------------------+---------------------+----------+----------+-------------+-----------------------
>  pg_catalog | area | double precision | box                 | postgres |
> internal | box_area    | box area
>  pg_catalog | area | double precision | circle              | postgres |
> internal | circle_area | area of circle
>  pg_catalog | area | double precision | path                | postgres |
> internal | path_area   | area of a closed path
> (3 rows)
> 
> template1=# \x
> Expanded display is on.
> template1=# \df+ area
> List of functions
> -[ RECORD 1 ]-------+----------------------
> Schema              | pg_catalog
> Name                | area
> Result data type    | double precision
> Argument data types | box
> Owner               | postgres
> Language            | internal
> Source code         | box_area
> Description         | box area
> -[ RECORD 2 ]-------+----------------------
> Schema              | pg_catalog
> Name                | area
> Result data type    | double precision
> Argument data types | circle
> Owner               | postgres
> Language            | internal
> Source code         | circle_area
> Description         | area of circle
> -[ RECORD 3 ]-------+----------------------
> Schema              | pg_catalog
> Name                | area
> Result data type    | double precision
> Argument data types | path
> Owner               | postgres
> Language            | internal
> Source code         | path_area
> Description         | area of a closed path
> 
> template1=# 
> 
> 
> certainly the second is much more legible... this is on... FC3 in case
> it matters. 
> 
> 
> Robert Treat
> -- 
> Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
> 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073