sqlalchemy.dialects.postgresql

package documentation
(source)

Undocumented

Module asyncpg .. dialect:: postgresql+asyncpg :name: asyncpg :dbapi: asyncpg :connectstring: postgresql+asyncpg://user:password@host:port/dbname[?key=value&key=value...] :url: https://magicstack.github...
Module base .. dialect:: postgresql :name: PostgreSQL :full_support: 9.6, 10, 11, 12, 13, 14 :normal_support: 9.6+ :best_effort: 9+
Module dml No module docstring; 1/1 function, 1/4 class documented
Module ext No module docstring; 0/1 type variable, 6/7 classes documented
Module hstore No module docstring; 0/1 variable, 0/8 constant, 3/3 functions, 2/9 classes documented
Module json No module docstring; 0/1 variable, 0/10 constant, 2/3 classes documented
Module named_types Undocumented
Module pg8000 .. dialect:: postgresql+pg8000 :name: pg8000 :dbapi: pg8000 :connectstring: postgresql+pg8000://user:password@host:port/dbname[?key=value&key=value...] :url: https://pypi.org/project/pg8000/...
Module pg_catalog Undocumented
Module provision No module docstring; 1/8 function documented
Module psycopg .. dialect:: postgresql+psycopg :name: psycopg (a.k.a. psycopg 3) :dbapi: psycopg :connectstring: postgresql+psycopg://user:password@host:port/dbname[?key=value&key=value...] :url: https://pypi...
Module psycopg2 .. dialect:: postgresql+psycopg2 :name: psycopg2 :dbapi: psycopg2 :connectstring: postgresql+psycopg2://user:password@host:port/dbname[?key=value&key=value...] :url: https://pypi.org/project/psycopg2/...
Module psycopg2cffi .. dialect:: postgresql+psycopg2cffi :name: psycopg2cffi :dbapi: psycopg2cffi :connectstring: postgresql+psycopg2cffi://user:password@host:port/dbname[?key=value&key=value...] :url: https://pypi...
Module ranges No module docstring; 0/3 variable, 0/1 type variable, 4/4 classes documented
Module types Undocumented
Module _psycopg_common Undocumented

From __init__.py:

Class aggregate_order_by Represent a PostgreSQL aggregate order by expression.
Class array A PostgreSQL ARRAY literal.
Class ARRAY PostgreSQL ARRAY type.
Class BIT Undocumented
Class BYTEA Undocumented
Class CIDR Undocumented
Class CreateDomainType Represent a CREATE DOMAIN statement.
Class CreateEnumType Undocumented
Class DATEMULTIRANGE Represent the PostgreSQL DATEMULTIRANGE type.
Class DATERANGE Represent the PostgreSQL DATERANGE type.
Class DOMAIN Represent the DOMAIN PostgreSQL type.
Class DropDomainType Represent a DROP DOMAIN statement.
Class DropEnumType Undocumented
Class ENUM PostgreSQL ENUM type.
Class ExcludeConstraint A table-level EXCLUDE constraint.
Class INET Undocumented
Class INT4MULTIRANGE Represent the PostgreSQL INT4MULTIRANGE type.
Class INT4RANGE Represent the PostgreSQL INT4RANGE type.
Class INT8MULTIRANGE Represent the PostgreSQL INT8MULTIRANGE type.
Class INT8RANGE Represent the PostgreSQL INT8RANGE type.
Class INTERVAL PostgreSQL INTERVAL type.
Class JSONPATH JSON Path Type.
Class MACADDR Undocumented
Class MACADDR8 Undocumented
Class MONEY Provide the PostgreSQL MONEY type.
Class NamedType Base for named types.
Class NUMMULTIRANGE Represent the PostgreSQL NUMMULTIRANGE type.
Class NUMRANGE Represent the PostgreSQL NUMRANGE type.
Class OID Provide the PostgreSQL OID type.
Class Range Represent a PostgreSQL range.
Class REGCLASS Provide the PostgreSQL REGCLASS type.
Class REGCONFIG Provide the PostgreSQL REGCONFIG type.
Class TIME PostgreSQL TIME type.
Class TIMESTAMP Provide the PostgreSQL TIMESTAMP type.
Class TSMULTIRANGE Represent the PostgreSQL TSRANGE type.
Class TSQUERY Provide the PostgreSQL TSQUERY type.
Class TSRANGE Represent the PostgreSQL TSRANGE type.
Class TSTZMULTIRANGE Represent the PostgreSQL TSTZRANGE type.
Class TSTZRANGE Represent the PostgreSQL TSTZRANGE type.
Class TSVECTOR The :class:`_postgresql.TSVECTOR` type implements the PostgreSQL text search type TSVECTOR.
Function All A synonym for the ARRAY-level :meth:`.ARRAY.Comparator.all` method. See that method for details.
Function Any A synonym for the ARRAY-level :meth:`.ARRAY.Comparator.any` method. See that method for details.
Function array_agg PostgreSQL-specific form of :class:`_functions.array_agg`, ensures return type is :class:`_postgresql.ARRAY` and not the plain :class:`_types.ARRAY`, unless an explicit ``type_`` is passed.
Variable psycopg_async Undocumented
def All(other, arrexpr, operator=operators.eq): (source)

A synonym for the ARRAY-level :meth:`.ARRAY.Comparator.all` method. See that method for details.

def Any(other, arrexpr, operator=operators.eq): (source)

A synonym for the ARRAY-level :meth:`.ARRAY.Comparator.any` method. See that method for details.

def array_agg(*arg, **kw): (source)

PostgreSQL-specific form of :class:`_functions.array_agg`, ensures return type is :class:`_postgresql.ARRAY` and not the plain :class:`_types.ARRAY`, unless an explicit ``type_`` is passed. .. versionadded:: 1.1

psycopg_async = (source)

Undocumented