Re: output screen in psql

Hello

2011/3/10 abcdef <chuikingman(at)gmail(dot)com>:
> Hi, I use postgres in red hat linux .
> When I use psql and select the content of the table .
> I find the format is not tidy .
> I change align and unalign , the output is not filful my requirement.
> Any special setting that can change the line size like oralce to fit my
> requirement ???
> So, the whole table can be view within the screen of psql ???
>

try wrap mode http://archives.postgresql.org/pgsql-committers/2008-05/msg00126.php

you can try http://www.pgsql.cz/index.php/PostgreSQL_SQL_Tricks#psql_together_with_less

Regards

Pavel Stehule

> ===============
> kwokdb=#  select * from issue;
>  issue_id |                   issue_name                   |
> issue_description                  | issue_assig
> nee | issue_url | issue_type | issue_status | issue_priority |
> issue_resolution | duplicate_id | creator |     creation_date
>    | modifier |   modification_date   |   issue_due_date    |  creator_ip
> | issue_created_from_email | issue_modified_from
> _email
> ----------+------------------------------------------------+----------------------------------------------------+------------
> ----+-----------+------------+--------------+----------------+------------------+--------------+---------+-------------------
> ----+----------+-----------------------+---------------------+---------------+--------------------------+--------------------
> -------
>        3 | computer cannot power up                       | test data:
> computer cannot power up                |
>  1 |           |          2 |            8 |             16 |
> 20 |              |       1 | 2011-03-08 12:16:2
> 6.4 |          |                       | 2011-03-31 00:00:00 | 192.168.1.143
> |
>
> ======================
> kwokdb=# select * from issue;
> issue_id|issue_name|issue_description|issue_assignee|issue_url|issue_type|issue_status|issue_priority|issue_resolution|duplicate_id|creator|creation_date|modifier|modification_date|issue_due_date|creator_ip|issue_created_from_email|issue_modified_from_email
> 3|computer cannot power up|test data: computer cannot power
> up|1||2|8|16|20||1|2011-03-08 12:16:26.4|||2011-03-31
> 00:00:00|192.168.1.143||
> 4|VMware workstation cannot install in XP|test data: Vmware workstation
> cannot install in XP|4||4|8|16|23||4|2011-03-08
> 13:54:53.4||||192.168.1.143||
> 5|User cannot connect to wireless router by WIFI|User cannot connect to
> wireless router by WIFI|1||2|7|15|19||4|2011-03-08 14:03:37.1|||2011-03-29
> 00:00:00|192.168.1.143||
>
>
> --
> View this message in context: http://postgresql.1045698.n5.nabble.com/output-screen-in-psql-tp3422631p3422631.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>