Received: from virtual.zia.ms.it (root@virtual.zia.ms.it [195.103.158.42]) by hub.org (8.8.8/8.7.5) with ESMTP id EAA24005 for ; Fri, 4 Sep 1998 04:57:48 -0400 (EDT) Received: from link.it (rub080.pi00.c1.interbusiness.it [194.184.214.80]) by virtual.zia.ms.it (8.8.8/8.8.8) with ESMTP id KAA27652; Fri, 4 Sep 1998 10:57:10 +0200 Sender: federico@link.it Message-ID: <35EFAB65.80F7A51B@link.it> Date: Fri, 04 Sep 1998 10:57:09 +0200 From: Federico Passaro X-Mailer: Mozilla 4.03 [en] (X11; I; Linux 2.0.34 i586) MIME-Version: 1.0 To: Ronnie Doggart , PostgreSQL sql Subject: Re: [SQL] Forming Query References: <35EE83FD.426DC43F@netcomuk.co.uk> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Ronnie Doggart wrote: > Hi All, > > I want to prompt a user for information in a query. In Oracle the format > would be > > select part_no, description from pricing where part_no like '&1'; > > what is it using psql and postgresql. > > Regards > Ronnie Doggart At the best of my knowledge there is no such a feature in psql, but you can use a shell script like the following one: _________________________________________________________________ #!/bin/bash echo -n "Type Part No: " read PART_NO psql <