readline help

On Wednesday 13 Nov 2002 5:49 pm, Williams, Travis L, NPONS wrote:

I know that this has been talked about to death.. but I'm assuming I
installed postgres without readline because I don't have any histroy type
stuff is psql.. how hard is this to fix? The DB isn't in production yet
and I'd rather fix it before it goes.. Is there anything I can do to make
psql any friendlier?

Assuming you're on a linux system, just make sure you've got the readline /
readline-dev packages installed and ./configure again, make - PG should pick
it up.

You might want to setup phpPgAdmin (apache+php) or pgadmin (windows) clients -
gives you a non-command line view of your databases.

--
Richard Huxton

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Richard Huxton
Sent: Wednesday, November 13, 2002 20:18
To: Williams, Travis L, NPONS; pgsql-general@postgresql.org
Subject: Re: [GENERAL] readline help

On Wednesday 13 Nov 2002 5:49 pm, Williams, Travis L, NPONS wrote:

I know that this has been talked about to death.. but I'm assuming I
installed postgres without readline because I don't have any

histroy type

stuff is psql.. how hard is this to fix? The DB isn't in production yet
and I'd rather fix it before it goes.. Is there anything I can

do to make

psql any friendlier?

Assuming you're on a linux system, just make sure you've got the
readline /
readline-dev packages installed and ./configure again, make - PG
should pick
it up.

Well, make sure you have the readline *AND* the ncurse development package
installed !!! I spent an entire evening trying to figure out why I couldn't
get the readline support in PSQL until I discovered - through poking in the
configuration script itself - that you also need the ncurse developement
package (there are one or two alternative to ncurse, but I don't remember
which).

Hope this helps ;-)