Re: [sqlalchemy] How to create table from select statements in sqlalchemy

I would like create table as select statement http://www.postgresql.org/docs/8.1/static/sql-createtableas.html On 1 June 2015 at 20:48, Mike Bayer mike...@zzzcomputing.com wrote: On 6/1/15 9:39 AM, Ranjith Ramachandra wrote: I am using sqlalchemy's core features do write some abstraction

Re: [sqlalchemy] How to create table from select statements in sqlalchemy

On 6/1/15 9:39 AM, Ranjith Ramachandra wrote: I am using sqlalchemy's core features do write some abstraction layer. The layer itself needs to be able to create tables from select statements. Sample code: metadata = MetaData(bind=engine) table = Table(table_name, metadata,

Re: [sqlalchemy] How to create table from select statements in sqlalchemy

On 6/1/15 11:19 AM, Ranjith wrote: I would like create table as select statement http://www.postgresql.org/docs/8.1/static/sql-createtableas.html OK but also you want to use bound parameters, apparently. I've answered the question at http://stackoverflow.com/a/30577608/34549. On 1

[sqlalchemy] How to create table from select statements in sqlalchemy

I am using sqlalchemy's core features do write some abstraction layer. The layer itself needs to be able to create tables from select statements. Sample code: metadata = MetaData(bind=engine) table = Table(table_name, metadata, autoload=True, autoload_with=engine) s =