You can make it interactive if you are working from a unix box.
[EMAIL PROTECTED]:~$ more zip.sql
\echo -n 'Zip to search for: '
\set value `read input; echo $input`
select * from zipcode where zip = :value
Not sure how/if you could do this on a windows box.
Take Care,
James
On Thursday 25 Marc
Hi all,
I have a question regarding psql. As I am more familiar with oracle I
can write the following select and make it rather flexible:
select name
from name_table
where person_id = &id;
The &id portion is what I am looking for in PostgreSQL. Basically when
running this query, the person runni