Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2009
    Posts
    54

    Unanswered: postgres "pager"

    Is there a way to tell postgres to use a command like "cat" to show the result of queries instead than "more". I'm saying this because on my openbsd system, if I use "more" to view a file which contains chinese characters I get garbled output if the file is over one page, but if I use "cat" everything is fine. As you imagine, I have the same behaviour with postgres. Is there a way to do it? For the moment I redirect output to a file and then "cat" it, but when you need to do it many times it becomes tedious.
    Thank you

  2. #2
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    Check out the environment variable PAGER

    PostgreSQL: Documentation: Manuals: PostgreSQL 8.3: psql

  3. #3
    Join Date
    Feb 2009
    Posts
    54
    cool!
    thanks a lot!

  4. #4
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    Next time, have a look at the manual first

  5. #5
    Join Date
    Feb 2009
    Posts
    54
    Sorry, today I'm going through a lot of manpages to solve some other problems and forgot about the postgres one.

Posting Permissions

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