How to create table from select statements in sqlalchemy

[Ranjith Ramachandra]

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 = select(table).where(table.c.column_1 > 10)

Now what I want to be able to is create a new table from the select statement above. How can I do it?

[Ranjith Ramachandra]

I have also asked the question at http://stackoverflow.com/questions/30575111/how-to-create-a-new-table-from-select-statement-in-sqlalchemy

[Mike Bayer]

can you be more specific?  What DDL would you like to emit ?

--
You received this message because you are subscribed to the Google Groups "sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+...@googlegroups.com.
To post to this group, send email to sqlal...@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.

[Ranjith]

I would like create table as select statement

http://www.postgresql.org/docs/8.1/static/sql-createtableas.html

--
You received this message because you are subscribed to a topic in the Google Groups "sqlalchemy" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/sqlalchemy/lKDkX68fOqI/unsubscribe.
To unsubscribe from this group and all its topics, send an email to sqlalchemy+...@googlegroups.com.

[Mike Bayer]

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.