Hello 2011/3/10 abcdef <chuikingman@xxxxxxxxx>: > 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@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
