From faa5a9067661039dcc8663e00bdcea2d098c9989 Mon Sep 17 00:00:00 2001 From: Malik Diarra Date: Sun, 17 Aug 2014 16:56:53 +0200 Subject: Adding postgres create table options documentation --- lib/sqlalchemy/dialects/postgresql/base.py | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) (limited to 'lib/sqlalchemy/dialects/postgresql/base.py') diff --git a/lib/sqlalchemy/dialects/postgresql/base.py b/lib/sqlalchemy/dialects/postgresql/base.py index 057a5e072..34932520f 100644 --- a/lib/sqlalchemy/dialects/postgresql/base.py +++ b/lib/sqlalchemy/dialects/postgresql/base.py @@ -417,6 +417,22 @@ of :class:`.PGInspector`, which offers additional methods:: .. autoclass:: PGInspector :members: +PostgreSQL specific table options +--------------------------------- + +PostgreSQL provides several CREATE TABLE specific options allowing to +specify how table data are stored. The following options are currently +supported: ``TABLESPACE``, ``ON COMMIT``, ``WITH OIDS``. + +``postgresql_tablespace`` is probably the more common and allows to specify +where in the filesystem the data files for the table will be created (see +http://www.postgresql.org/docs/9.3/static/manage-ag-tablespaces.html) + +.. seealso:: + + `Postgresql CREATE TABLE options + `_ - + on the PostgreSQL website """ from collections import defaultdict -- cgit v1.2.1