Re: Command to execute SQL string

Hello Francisco,

thank you !

Jacek is the same as Łukasz. Is my second name and my artist's nickname ;-)

love your answer,
thank you!

Best,
Jacek

2018-03-08 13:40 GMT+01:00 Francisco Olarte <folarte(at)peoplecall(dot)com>:

> Hello:
>
>
>
> On Thu, Mar 8, 2018 at 1:26 PM, Łukasz Jarych <jaryszek(at)gmail(dot)com> wrote:
> > i have a table when i have string in each row,
> > for example "DELETE FROM t_test WHERE ID = 3".
> >
> > I want to execute for each row this command.
> > It is possible?
>
> I supose you mean execute the command contained in each row. Anyway,
> it is easy with a procedure, look for example at
>
> https://www.postgresql.org/docs/10/static/plpgsql-statements.html#PLPGSQL-
> STATEMENTS-EXECUTING-DYN
>
> just do a loop on your command table, follow the examples and you
> should be done.
>
> Francisco Olarte.
>
> PS:
> > Jacek
> Is this the same as Łukasz or Jarych ?
>
> F.O.
>