Put it into a shell script like echo "select * from mytable where id = $1;" | psql $DBNAME
That can be executed using the shell function in psql \! [COMMAND] execute command in shell or start interactive shell regards, -Andreas On Wednesday 28 April 2004 17:46, Ben Kim wrote: > 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? > > Thanks, > Ben Kim > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org -- ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly