Hello!
I want to run a shell script with variables under Postgresql.
An example:
I want to make the following query;
select * from tablename where id=1;
select * from tablename where id=2;
select * from tablename where id=3;
select * from tablename where id=4;
.........
Is it possible to do it this way and what is the right syntax. All i've
tried out didn't work.
while i<100 do
select * from tablename where id=i;
i=i+1;
done
Thanks for your help.
Greetings
Maik