plpgsql execution - Mailing list pgsql-admin

From Girish Bajaj
Subject plpgsql execution
Date
Msg-id 002301c35272$f773d9e0$7764a8c0@tietronix.com
Whole thread Raw
Responses Re: plpgsql execution
List pgsql-admin

Is there any way I can run the following code in the query executer without creating a function for it?

 

FOR i IN 1..100 LOOP

PERFORM time_delay(1);

insert into worklist(startid, endid, cellid, campaignid, status, claim, flastjob) values(1,2,3,4,5,\'mju\',CAST(1 as BIT));

END LOOP;

 

The language is PLPGSQL. And I really don’t want to write a function to execute it. Can the query executer automatically execute it for me?

 

Thanks,

Girish

 

 

pgsql-admin by date:

Previous
From: "Dilan Arumainathan"
Date:
Subject: SQL Server DTS for data migration
Next
From: Sub Director - Sistemas Informáticos
Date:
Subject: \connect ...ing since a dbserver to another