Create materialized view with reflected metadata

[Stefan Urbanek]

Hi,

We are trying to create a materialized view (PostgreSQL). We have this 
simple statement compiler:

class CreateMaterializedView(Executable, ClauseElement):
    def __init__(self, name, select):
        self.name = name
        self.select = select

@compiles(CreateMaterializedView)
def visit_create_materialized_view(element, compiler, **kw):
    
    return "CREATE MATERIALIZED VIEW {} AS {}".format(
         element.name,
         compiler.process(element.select, literal_binds=True)
         )


What is the clean way to get the actual reflected metadata (Table object) 
to construct the `select` element for the CreateMaterializedView?

Thanks,

Stefan

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