I am using psycopg2 to read from one database table and insert these into another table. I get a format error when the value I am trying to insert has a space in it. The condensed code looks like:
cursor.execute("""INSERT INTO table (column1, column2)
VALUES ('start finish','now later')""")
I'm a newbie to psycopg2 but this seems like a silly limitation. Any ideas for a work-around?