Skip to content

fkarb/sqlalchemy_pgcatalog

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

SQLAlchemy PostgreSQL Catalog Definition

SQLAlchemy schema definition (partially reflected) for the PostgreSQL catalog (pg_catalog schema)

Example

Simple example:

>>> 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)]

About

SQLAlchemy PostgreSQL Catalog Definition

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages