Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2011
    Posts
    2

    Unanswered: output screen in psql

    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_assign ee|issue_url|issue_type|issue_status|issue_priorit y|issue_resolution|duplicate_id|creator|creation_d ate|modifier|modification_date|issue_due_date|crea tor_ip|issue_created_from_email|issue_modified_fro m_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||

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    According to the manual

    \pset format unaligned

    should do this

    Quote Originally Posted by Postgres Manual
    unaligned format writes all columns of a row on one line, separated by the currently active field separator. This is useful for creating output that might be intended to be read in by other programs (for example, tab-separated or comma-separated format).
    More details here:
    http://www.postgresql.org/docs/current/static/app-psql.html

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •