title: How to escape single quotes in Unload
body: <pre><code>    conn_string = "dbname='{}' port='{}' user='{}' password='{}' host='{}'"\
              .format(dbname,port,user,password,host_url) 
  
      sql="""UNLOAD ('select col1,col2 from %s.visitation_hourly_summary_us where col4= '2018-07-10' and col5= '1';') TO 's3://%s/%s/%s.csv' \
              credentials 'aws_access_key_id=%s;aws_secret_access_key=%s' \
              MANIFEST GZIP ALLOWOVERWRITE;Commit;""" \
              % (schema_name,s3_bucket_name, schema,table,aws_access_key_id,\
              aws_secret_access_key)
  
  con = psycopg2.connect(conn_string)
  cur = con.cursor()
  cur.execute(sql)
  </code></pre>
  
  <p>I'm trying to execute the above script to read the table and then create a file in S3</p>
  
  <p>Since my columns are string I'm not able to skip the single quotes and I'm getting error as syntax error near where </p>
  
  <p>Also, I've tried giving \ in where condition still it showing the same error.  </p>
  
  <p>Any help would be highly appreciated.</p>
  
  <p>Thanks</p>