Using sqlalchemy to inspect a postgres database

create_tablestring.py

import sqlalchemy

engine = sqlalchemy.create_engine("postgresql+psycopg2:///lars")
meta = sqlalchemy.schema.MetaData()
meta.reflect(bind=engine)
inspector = sqlalchemy.inspect(engine)
default_schema_name = inspector.default_schema_name
schema_names = inspector.get_schema_names()

def create_tables(if_exists: bool = False) -> str:

    return "\n".join(
        [
            str(
                sqlalchemy.schema.CreateTable(table, if_not_exists=if_exists).compile(
                    engine
                )
            )
            for table in meta.sorted_tables
        ]
    )

print(create_tables())