I tried but couldn't find an answer if this is possible in psql.
Create a file named test.sql
select * from mytable where id = ? (or use $1, $2...)
Then in psql do
\i test.sql 337
to achieve the same effect "select * from mytable where id=337"
as I would in perl
$sth = $dbh -> prepare ("insert into mytable values (?, ?, ?)")
Is writing a function the only way? Is there another way that can be done
without writing a function?
pgsql-admin by date
|Next:||From: Andreas Schmitz||Date: 2004-04-28 16:06:20|
|Subject: Re: parametrized query|
|Previous:||From: Bruno Wolff III||Date: 2004-04-28 08:32:23|
|Subject: Re: [JDBC] [PERFORM] is a good practice to create an index on the|