Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id eAO0BlA19391 for ; Thu, 23 Nov 2000 19:11:47 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from freek.imc ([216.18.11.44]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id eANNgeA18411 for ; Thu, 23 Nov 2000 18:42:41 -0500 (EST) (envelope-from clayton@marketingchallenge.com) Received: (qmail 7383 invoked from network); 23 Nov 2000 23:42:47 -0000 Received: from cerberus.imc (HELO marketingchallenge.com) (216.18.11.61) by freek.imc with SMTP; 23 Nov 2000 23:42:47 -0000 Message-ID: <3A1DAB90.9BDC08E0@marketingchallenge.com> Date: Thu, 23 Nov 2000 15:43:12 -0800 From: clayton cottingham X-Mailer: Mozilla 4.75 [en] (X11; U; Linux 2.2.17-21mdk i686) X-Accept-Language: en MIME-Version: 1.0 To: Joe Conway CC: Peter Eisentraut , sqllist Subject: Re: psql question References: <03db01c05598$fce41590$0705a8c0@jecw2k1> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200011/214 X-Sequence-Number: 245 Joe Conway wrote: > > > > On machines where I've installed PostgreSQL 7.0.2 from RPM, psql allows > use > > > of the up arrow key for history and the escape/tab key for command > > > completion, but on my remote web host (webpipe.net) those keys don't > work. > > > What do I need to do to get these features working on my remote web > host? > > > I've seen reference to .psqlrc in the psql man file, but not much else > (no > > > syntax, etc). > > > > If you compiled from source, make sure you had the readline-devel package > > installed. > > > > Thanks for your responses, Peter & Mathijs. > > Actually, since the issue is on a hosted system, I don't have access to > recompile. I was hoping that maybe there would be something I could > configure from my own (non-root and non-postgres) account. > > My question actaully took several days just to make it to the list, so in > the meantime I found my own work-around -- I copied local copies of psql and > libpq up to my account on the web host. Then I put my own account folder to > the front of the PATH and added a LD_LIBRARY_PATH. Now when I run 'psql' it > works just like on my own machine! > > Thanks again for the response. > > Joe you could use a version of pgsql on your own machine and use the host switch to connect to an extrenal db of course your db isp will have to allow your ip to connect, not an easy thing if your dial up!! this way you could recompile your own ver of psql hope that helps