python - how to properly quote sql string

Question

How do I properly quote this string this postgres sql syntax within my python script which uses psycopg2's cur.execute ("SELECT .. ")

Postgres sql:

SELECT 'ALTER TABLE RENAME ' || tablename || ' TO ' || 
  REGEXP_REPLACE ( tablename, '_foo$', '_bar' ) || ';'
FROM pg_tables
WHERE tablename LIKE '%_foo';

Within my python script:

  cur.execute("SELECT 'ALTER TABLE RENAME ' || tablename || ' TO ' ||
                REGEXP_REPLACE ( tablename, '_foo$', '_bar' ) || ';'
                FROM pg_tables
                WHERE tablename LIKE '%_foo'")

Parfait · Accepted Answer · 2015-06-01 03:48:01Z

1

Simply, add line breaks:

cur.execute("SELECT 'ALTER TABLE RENAME ' || tablename || ' TO ' || \
             REGEXP_REPLACE ( tablename, '_foo$', '_bar' ) || ';' \
             FROM pg_tables \
             WHERE tablename LIKE '%_foo'")

answered Jun 1, 2015 at 3:48

Parfait

108k19 gold badges103 silver badges138 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

b4hand Over a year ago

Better yet, use triple quotes (""") to avoid backslash escapes for multiline strings.

Collectives™ on Stack Overflow

python - how to properly quote sql string

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related