1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

output screen in psql

Discussion in 'MySQL' started by abcdefghi, Mar 10, 2011.

  1. abcdefghi

    abcdefghi New Member

    Joined:
    Mar 9, 2011
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    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 ???
    ===============
    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||
     

Share This Page