summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMalik Diarra <malik.diarra@gmail.com>2014-08-17 16:56:53 +0200
committerMalik Diarra <malik.diarra@gmail.com>2014-08-17 16:56:53 +0200
commitfaa5a9067661039dcc8663e00bdcea2d098c9989 (patch)
tree63f4bdd667627ffd7bdd2ba5c210019348a39f88
parent9eacc8d42ad49527c7fd0fe7e37100edba9eb1dc (diff)
downloadsqlalchemy-pr/129.tar.gz
Adding postgres create table options documentationpr/129
-rw-r--r--lib/sqlalchemy/dialects/postgresql/base.py16
1 files changed, 16 insertions, 0 deletions
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
+ <http://www.postgresql.org/docs/9.3/static/sql-createtable.html>`_ -
+ on the PostgreSQL website
"""
from collections import defaultdict