title: Copy Postgres-Table with Python (sqlalchemy) but can't change the target schema
body: <p>I am trying to copy a table from one postgres database (dss_test) to another (dss_prod) using the Python module sqlalchemy. I want to copy the metadata too (e. g. datatypes, constraints etc.).</p>
  <p>I created two engines, one for the source database and one for the target database.</p>
  <pre><code>src_engine = sqlalchemy.create_engine('postgresql+psycopg2://'+authTokens[0]+':'+authTokens[2]+'@localhost:5432/dss_test', echo=True)
  trg_engine = sqlalchemy.create_engine('postgresql+psycopg2://'+authTokens[0]+':'+authTokens[2]+'@localhost:5432/dss_prod', echo=True)
  </code></pre>
  <p>After that I catch the metadata from the table in the source database...</p>
  <pre><code>meta = sqlalchemy.MetaData(bind=src_engine)
  table = sqlalchemy.Table('test_table', meta, schema='public', autoload=True)
  </code></pre>
  <p>...and create the new table in the target database.</p>
  <pre><code>table.metadata.create_all(trg_engine)
  </code></pre>
  <p>That works fine so far!</p>
  <p>The problem is, that the source table is in the schema 'public' but the target should be in the schema 'nonpublic'. If I execute my code the new table is also in the schema 'public'.</p>
  <p>Can I change the target schema?</p>
  <p>Possible solutions to my problem may involve the usage of another module (e. g. psycopg2 etc.)</p>
  <p>Take into consideration, that I have rights to read and write in the source database everywhere but in the target database only in the schema 'nonpublic'</p>
  <p>Thanks for any ideas.</p>