Re: plpython/python string formatting

On 8/16/22 16:42, Ted Toth wrote:
> I've just started playing with plpython but ran into a issue when I
> was trying to use standard python string formatting to generate a SQL
> string for example:
> s = "EXECUTE format('CREATE INDEX %s ON %s USING (column_name)' %
> (index_name, table_name))"
>
> but plpython then tried to run the EXECUTE instead of just setting
> variable 's'. Why does this happen?

Best guess is you are seeing cross platform collision with:

https://www.postgresql.org/docs/current/functions-string.html#FUNCTIONS-STRING-FORMAT

Why not?:

s = format('CREATE INDEX %s ON %s USING (column_name)' %
(index_name, table_name))

>
> Ted
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com