am 10.11.2005, um 10:10:22 +0100 mailte Maik Trömel folgendes:
> 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
for i in `seq 10` ; do
echo "select * from foo where id = $i" | psql test
done;
HTH, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47212, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
