SQLAlchemy and partitioning table [closed]

Question

Closed. This question needs details or clarity. It is not currently accepting answers.

Want to improve this question? As written, this question is lacking some of the information it needs to be answered. If the author adds details in comments, consider editing them into the question. Once there's sufficient detail to answer, vote to reopen the question.

Closed 5 days ago.

Improve this question

I have tables which are already in Postgres and partitioned. How can I write a query with partioned birth_year

stmt = select(UserOrm)
session.execute(stmt)`

Please provide a minimal reproducible example with sample data and desired results. — Dale K
– Dale K, Commented Nov 24 at 21:12

Mauricio Reisdoefer · Accepted Answer · 2025-11-24 21:36:57Z

0

When using partitioned tables in PostgreSQL, SQLAlchemy does not require any special syntax. You query them the same way you would query a regular table. PostgreSQL handles the partition pruning automatically.

stmt = select(UserOrm).where(UserOrm.birth_year == 1990)
result = session.execute(stmt).scalars().all()

answered Nov 24 at 21:36

Mauricio Reisdoefer

3487 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQLAlchemy and partitioning table [closed]

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related