Re: plpython/python string formatting

2022-08-16 Thread Adrian Klaver
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 plpytho

Re: plpython/python string formatting

2022-08-16 Thread Adrian Klaver
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 plpytho

plpython/python string formatting

2022-08-16 Thread Ted Toth
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 inst