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 eANN9HA16767 for ; Thu, 23 Nov 2000 18:09:17 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from femail8.sdc1.sfba.home.com (femail8.sdc1.sfba.home.com [24.0.95.88]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eANM1pA80363 for ; Thu, 23 Nov 2000 17:01:51 -0500 (EST) (envelope-from joe@conway-family.com) Received: from jecw2k1 ([24.0.42.111]) by femail8.sdc1.sfba.home.com (InterMail vM.4.01.03.00 201-229-121) with SMTP id <20001123220158.UJEU2160.femail8.sdc1.sfba.home.com@jecw2k1>; Thu, 23 Nov 2000 14:01:58 -0800 Message-ID: <03db01c05598$fce41590$0705a8c0@jecw2k1> From: "Joe Conway" To: "Peter Eisentraut" Cc: "sqllist" References: Subject: Re: psql question Date: Thu, 23 Nov 2000 14:01:52 -0800 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 X-Archive-Number: 200011/213 X-Sequence-Number: 244 > > 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