rlwrap can be used (and not just for psql!)

Posted Feb 16, 2011 19:01 UTC (Wed) by cortana (subscriber, #24596)
Parent article: PostgreSQL, OpenSSL, and the GPL

A safer/saner way to restore readline functionality:

$ rlwrap psql -n

rlwrap is a really great program. It will add readline functionality to any other line-oriented program.

rlwrap can be used (and not just for psql!)

Posted Feb 16, 2011 23:23 UTC (Wed) by davide.del.vento (guest, #59196) [Link] (1 responses)

Yes, rlwrap is very good.
But unfortunately it breaks autocompletion, so it's not a full substitute for readline.
I guess for the time being the real "solution" is for everybody to recompile their own psql against readline and openssl.

rlwrap can be used (and not just for psql!)

Posted Mar 13, 2011 22:23 UTC (Sun) by trekker.dk (guest, #65149) [Link]

Not that hard - at least in version 9.0.3 this worked:

# apt-get build-dep postgresql-client-9.0
$ apt-get source postgresql-client-9.0
$ cd postgresql-9.0-9.0.3/
$ fakeroot-sysv debian/rules binary
# dpkg -i postgresql-client-9.0_9.0.3-1_amd64.deb

Or something along those lines. $ and # characters denote privileges needed (root/user)

rlwrap can be used (and not just for psql!)

Posted Feb 20, 2011 10:24 UTC (Sun) by fjalvingh (guest, #4803) [Link]

Thank you! I did not know that!