SEO

#1 (**permalink**) 04-09-2008, 06:56 AM

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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

#2 (**permalink**) 04-09-2008, 06:56 AM

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

#3 (**permalink**) 04-09-2008, 06:56 AM

Hello!

How do you get the list of id's? If you get it while some calculating
you may get the list of them (1, 3, 6,...) and then produce the query

select * from tablename where id in (your_list)

Hope this helps,

Nicolay

Maik Trömel wrote:
> 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
>

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode