Thread: Psql & Readline

Psql & Readline

From
"Josh Berkus"
Date:
Folks,

I have a question for *you*:
 On one of my machines, psql will not allow me to use tab-completion
 and
  the "up" key to repeat commands. On other machines, this was because
  I didn't have the "readline" library installed. However, this machine
  does have it. What else am I missing?

-Josh

Re: Psql & Readline

From
Tom Lane
Date:
"Josh Berkus" <josh@agliodbs.com> writes:
>  On one of my machines, psql will not allow me to use tab-completion
>  and
>  the "up" key to repeat commands. On other machines, this was because
>  I didn't have the "readline" library installed. However, this machine
>  does have it. What else am I missing?

Did you build PG from source on that machine?  If so, I'll bet that
configure didn't find libreadline.  You could check this by seeing if
the psql executable references libreadline (try "ldd", or local
equivalent, eg "chatr" on HPUX).

The most common cause of this situation is that you installed the
libreadline RPM but not the libreadline-devel RPM.  You need both
to build a readline-using app from source.

            regards, tom lane