X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 84617D9FBA for ; Wed, 2 Nov 2005 19:40:35 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 67373-07 for ; Wed, 2 Nov 2005 23:40:30 +0000 (GMT) Received: from brmea-mail-3.sun.com (brmea-mail-3.Sun.COM [192.18.98.34]) by svr1.postgresql.org (Postfix) with ESMTP id 2028BD9C81 for ; Wed, 2 Nov 2005 19:40:32 -0400 (AST) Received: from phys-hanwk-1 ([129.149.2.111]) by brmea-mail-3.sun.com (8.12.10/8.12.9) with ESMTP id jA2NeY3F007466 for ; Wed, 2 Nov 2005 16:40:34 -0700 (MST) Received: from conversion-daemon.hanwk-mail1.sfbay.sun.com by hanwk-mail1.sfbay.sun.com (iPlanet Messaging Server 5.2 HotFix 1.24 (built Dec 19 2003)) id <0IPC00K01PLRBU@hanwk-mail1.sfbay.sun.com> (original mail from Ashok.Agrawal@Sun.COM) for pgsql-sql@postgresql.org; Wed, 02 Nov 2005 15:40:34 -0800 (PST) Received: from Sun.COM (sr1-unwk-09.SFBay.Sun.COM [129.149.2.159]) by hanwk-mail1.sfbay.sun.com (iPlanet Messaging Server 5.2 HotFix 1.24 (built Dec 19 2003)) with ESMTP id <0IPC00JMNPRL1Q@hanwk-mail1.sfbay.sun.com>; Wed, 02 Nov 2005 15:40:34 -0800 (PST) Date: Wed, 02 Nov 2005 15:40:33 -0800 From: Ashok Agrawal Subject: User input in psql To: pgsql-sql@postgresql.org, tgl@sss.pgh.pa.us Reply-To: Ashok.Agrawal@Sun.COM Message-id: <43694E71.4080208@Sun.COM> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7BIT X-Accept-Language: en-us, en User-Agent: Mozilla/5.0 (X11; U; SunOS sun4u; en-US; rv:1.4) Gecko/20041214 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.001 required=5 tests=[AWL=-0.001, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.001 X-Spam-Level: X-Archive-Number: 200511/37 X-Sequence-Number: 23289 Hi . Just wanted to know what is equivalent of "Oracle &" in postgresql. select count(*) from table1 where id =&1 where sqlplus plus will prompt to enter value for 1. I would like to do the same in psql. Thanks Ashok