PostgreSQL目录表的SQLAlchemy定义
sqlalchemy_pgcatalog的Python项目详细描述
sqlalchemy postgresql目录定义
postgresql目录(pg_catalog schema)的sqlalchemy模式定义(部分反映)
示例
简单示例:
>>> import sqlalchemy >>> import sqlalchemy_pgcatalog >>> engine = sqlalchemy.create_engine("postgresql://localhost:5432/examples") >>> list(engine.execute(select([sqlalchemy_pgcatalog.Lock]))) [('relation', 320034, 11090, None, None, None, None, None, None, None, '2/77352', 23112, 'AccessShareLock', True, True), ('virtualxid', None, None, None, None, '2/77352', None, None, None, None, '2/77352', 23112, 'ExclusiveLock', True, True)]