plpython/python string formatting - Mailing list pgsql-general

From Ted Toth
Subject plpython/python string formatting
Date
Msg-id CAFPpqQESdqgk4ZM4n7Rxzh9X1VU77kjOt0xk1SL6rMPmVsVfFQ@mail.gmail.com
Whole thread Raw
Responses Re: plpython/python string formatting
Re: plpython/python string formatting
List pgsql-general
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?

Ted



pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: plpython questions
Next
From: Adrian Klaver
Date:
Subject: Re: plpython/python string formatting