Postgres Pro
Downloads
Home   >   mailing lists

Re: Select works only when connected from login postgres - Mailing list pgsql-general

From David G. Johnston
Subject Re: Select works only when connected from login postgres
Date
Msg-id CAKFQuwZ2cmj-f3hXJUCAvWGAmVzq5d-EBA-ZZMo1auaMAWfORw@mail.gmail.com
Whole thread Raw
In response to Re: Select works only when connected from login postgres  (Joseph Brenner <doomvox@gmail.com>)
Responses Re: Select works only when connected from login postgres
List pgsql-general
Tree view
On Mon, Dec 5, 2016 at 9:53 PM, Joseph Brenner <doomvox@gmail.com> wrote:
And I guess I did that intentionally, my .bashrc has

  # I use emacs shells, I got a "pager" already:
  export PAGER=''


​PAGER= psql --pset=pager=always -c 'select 1;'​
<nothing on the screen>

Remove PAGER= and I'm good.

I guess that psql could be a bit more helpful by reporting something to stderr if the value of PAGER is not an executable (platform dependent...)

I find it a bit odd that all of your queries were using the pager...did I miss where you reported that setting?

David J.

pgsql-general by date:

Previous
From: Joseph Brenner
Date:
Subject: Re: Select works only when connected from login postgres
Next
From: Joseph Brenner
Date:
Subject: Re: Select works only when connected from login postgres