]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
postgresql dialect table options
authorFederico Caselli <cfederico87@gmail.com>
Wed, 18 Jun 2025 20:22:59 +0000 (16:22 -0400)
committerFederico Caselli <cfederico87@gmail.com>
Tue, 14 Oct 2025 17:47:26 +0000 (19:47 +0200)
commit1dd96d274d78ed6ae57de631e8a326857d1b59fc
treec6cd8ae7b3b4bb07b036b1d013ccb4da74acdc89
parent52bbb8130be3dd8f194e6fba4755ce5a1f7b9ad9
postgresql dialect table options

Support for storage parameters in ``CREATE TABLE`` using the ``WITH``
clause has been added. The ``postgresql_with`` dialect option of
:class:`_schema.Table` accepts a mapping of key/value options.

The PostgreSQL dialect now support reflection of table options, including
the storage parameters, table access method and table spaces. These options
are automatically reflected when autoloading a table, and are also
available via the :meth:`_engine.Inspector.get_table_options` and
:meth:`_engine.Inspector.get_multi_table_optionsmethod` methods.

Fixes: #10909
Closes: #12584
Closes: #12684
Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/12584
Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/12684
Pull-request-sha: a660459de9adcedb2d12eac72450747c04792bcd

Change-Id: I33e3d8b8eb0c02530933cb124e3d375ca4af7db2
doc/build/changelog/unreleased_21/10909.rst [new file with mode: 0644]
lib/sqlalchemy/dialects/postgresql/base.py
lib/sqlalchemy/dialects/postgresql/pg_catalog.py
test/dialect/postgresql/test_compiler.py
test/dialect/postgresql/test_reflection.py
test/requirements.py