diff options
| author | mike bayer <mike_mp@zzzcomputing.com> | 2018-03-30 16:22:43 -0400 |
|---|---|---|
| committer | Gerrit Code Review <gerrit@ci.zzzcomputing.com> | 2018-03-30 16:22:43 -0400 |
| commit | 1e5cda65a157c56e1c522511589bc8842de33d9c (patch) | |
| tree | 215f53a8a1d804c2c2c5b706406b507c77746b0d /lib/sqlalchemy/dialects/postgresql/base.py | |
| parent | 85af25b7d1dbf21f2607739de74067684ef37dd1 (diff) | |
| parent | 0174d698a8ed155b51cc44c503b10bc67b16dfc9 (diff) | |
| download | sqlalchemy-1e5cda65a157c56e1c522511589bc8842de33d9c.tar.gz | |
Merge "Add support for declarative partitioning in PostgreSQL 10"
Diffstat (limited to 'lib/sqlalchemy/dialects/postgresql/base.py')
| -rw-r--r-- | lib/sqlalchemy/dialects/postgresql/base.py | 13 |
1 files changed, 12 insertions, 1 deletions
diff --git a/lib/sqlalchemy/dialects/postgresql/base.py b/lib/sqlalchemy/dialects/postgresql/base.py index 5ae27a996..1dffe8db9 100644 --- a/lib/sqlalchemy/dialects/postgresql/base.py +++ b/lib/sqlalchemy/dialects/postgresql/base.py @@ -780,7 +780,14 @@ dialect in conjunction with the :class:`.Table` construct: Table("some_table", metadata, ..., postgresql_inherits=("t1", "t2", ...)) -.. versionadded:: 1.0.0 + .. versionadded:: 1.0.0 + +* ``PARTITION BY``:: + + Table("some_table", metadata, ..., + postgresql_partition_by='LIST (part_column)') + + .. versionadded:: 1.2.6 .. seealso:: @@ -1829,6 +1836,9 @@ class PGDDLCompiler(compiler.DDLCompiler): ', '.join(self.preparer.quote(name) for name in inherits) + ' )') + if pg_opts['partition_by']: + table_opts.append('\n PARTITION BY %s' % pg_opts['partition_by']) + if pg_opts['with_oids'] is True: table_opts.append('\n WITH OIDS') elif pg_opts['with_oids'] is False: @@ -2166,6 +2176,7 @@ class PGDialect(default.DefaultDialect): (schema.Table, { "ignore_search_path": False, "tablespace": None, + "partition_by": None, "with_oids": None, "on_commit": None, "inherits": None |