title: Get rid of double quotation marks with SQLalchemy for PostgreSQL
body: <p>I'm trying to import 200 SAS XPT files to my PostgreSQL database:</p>
  
  <pre><code>engine = create_engine('postgresql://user:pwd@server:5432/dbName')
  for file in listdir(dataPath):
      name, ext = file.split('.', 1)
      with open(join(dataPath, file), 'rb') as f:
          xport.to_dataframe(f).to_sql(name, engine, schema='schemaName', if_exists='replace', index=False)
      print("Successfully wrote ", file, " to database.")
  </code></pre>
  
  <p>However, the SQL generated has double quotation marks for all identifiers, for example: <code>CREATE TABLE "Y2009"."ACQ_F" ("SEQN" FLOAT(53), "ACD010A" FLOAT(53));</code>. The problem is, if the column / table / schema is created with quotation marks, every time I need to query them, I must include the quotation marks as well, at the same time <a href="http://blog.lerner.co.il/quoting-postgresql/" rel="noreferrer">use the exact capitalization</a>.</p>
  
  <p>I want to get rid of quotation marks, while I cannot write custom SQLs myself, because these files each has very different structure.</p>