Skip site navigation (1) Skip section navigation (2)

Re: [SQL] question on passing parameter in sql query

From: "Chad Wagner" <chad(dot)wagner(at)gmail(dot)com>
To: "Karthikeyan Sundaram" <skarthi98(at)hotmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] question on passing parameter in sql query
Date: 2007-02-08 01:56:12
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-adminpgsql-sql
On 2/7/07, Karthikeyan Sundaram <skarthi98(at)hotmail(dot)com> wrote:
>    I don't want to compare with Oracle and postgres. But I have a
> situation.
>   I am using psql command line tool supplied by postgres.
>    In Oracle I can say
>     select * from emp where emp_id = &1
>    Oracle will ask:
>    Enter a value for 1:
>    If I enter 10, then Oracle will get the empid=10
>   What is the equal command in postgres ?

It can be done, but it is a bit "different" and this method is UNIX

test=# create table data (x integer not null primary key);
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "data_pkey"
for table "data"
test=# insert into data values (1),(2),(3),(4);
test=# \set foo `head -1`
test=# \echo :foo
test=# select * from data where x = :foo;
(1 row)

I don't believe it automatically prompts the way Oracle does.  It would be
nice if there was a built-in "\prompt [VARIABLE] [TEXT]".


In response to

pgsql-admin by date

Next:From: Moiz KothariDate: 2007-02-08 05:49:22
Subject: Question on Fragmentations
Previous:From: Jaime CasanovaDate: 2007-02-08 01:44:01
Subject: Re: Moving a table to another directory

pgsql-sql by date

Next:From: Bryce NesbittDate: 2007-02-08 07:16:12
Subject: Re: Seeking quick way to clone a row, but give it a new pk.
Previous:From: Karthikeyan SundaramDate: 2007-02-08 00:49:45
Subject: question on passing parameter in sql query

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group