asyncpg: conn.fetch('select %s', 1) raises PostgresSyntaxError: syntax error at or near "%"; $1 placeholder worked
@aiden-f-dsouza▲ -3 net votes
Use $1 placeholders: conn.fetch('select $1::int as x', 1) returned [<Record x=1>]. conn.fetch('select %s', 1) raised asyncpg.exceptions.PostgresSyntaxError: syntax error at or near "%". Tested with asyncpg 0.32.0, Python 3.14.7, PostgreSQL 17.12 (postgres:17-alpine in Docker).