__init__.py 3.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167
  1. # dialects/postgresql/__init__.py
  2. # Copyright (C) 2005-2025 the SQLAlchemy authors and contributors
  3. # <see AUTHORS file>
  4. #
  5. # This module is part of SQLAlchemy and is released under
  6. # the MIT License: https://www.opensource.org/licenses/mit-license.php
  7. # mypy: ignore-errors
  8. from types import ModuleType
  9. from . import array as arraylib # noqa # keep above base and other dialects
  10. from . import asyncpg # noqa
  11. from . import base
  12. from . import pg8000 # noqa
  13. from . import psycopg # noqa
  14. from . import psycopg2 # noqa
  15. from . import psycopg2cffi # noqa
  16. from .array import All
  17. from .array import Any
  18. from .array import ARRAY
  19. from .array import array
  20. from .base import BIGINT
  21. from .base import BOOLEAN
  22. from .base import CHAR
  23. from .base import DATE
  24. from .base import DOMAIN
  25. from .base import DOUBLE_PRECISION
  26. from .base import FLOAT
  27. from .base import INTEGER
  28. from .base import NUMERIC
  29. from .base import REAL
  30. from .base import SMALLINT
  31. from .base import TEXT
  32. from .base import UUID
  33. from .base import VARCHAR
  34. from .dml import Insert
  35. from .dml import insert
  36. from .ext import aggregate_order_by
  37. from .ext import array_agg
  38. from .ext import ExcludeConstraint
  39. from .ext import phraseto_tsquery
  40. from .ext import plainto_tsquery
  41. from .ext import to_tsquery
  42. from .ext import to_tsvector
  43. from .ext import ts_headline
  44. from .ext import websearch_to_tsquery
  45. from .hstore import HSTORE
  46. from .hstore import hstore
  47. from .json import JSON
  48. from .json import JSONB
  49. from .json import JSONPATH
  50. from .named_types import CreateDomainType
  51. from .named_types import CreateEnumType
  52. from .named_types import DropDomainType
  53. from .named_types import DropEnumType
  54. from .named_types import ENUM
  55. from .named_types import NamedType
  56. from .ranges import AbstractMultiRange
  57. from .ranges import AbstractRange
  58. from .ranges import AbstractSingleRange
  59. from .ranges import DATEMULTIRANGE
  60. from .ranges import DATERANGE
  61. from .ranges import INT4MULTIRANGE
  62. from .ranges import INT4RANGE
  63. from .ranges import INT8MULTIRANGE
  64. from .ranges import INT8RANGE
  65. from .ranges import MultiRange
  66. from .ranges import NUMMULTIRANGE
  67. from .ranges import NUMRANGE
  68. from .ranges import Range
  69. from .ranges import TSMULTIRANGE
  70. from .ranges import TSRANGE
  71. from .ranges import TSTZMULTIRANGE
  72. from .ranges import TSTZRANGE
  73. from .types import BIT
  74. from .types import BYTEA
  75. from .types import CIDR
  76. from .types import CITEXT
  77. from .types import INET
  78. from .types import INTERVAL
  79. from .types import MACADDR
  80. from .types import MACADDR8
  81. from .types import MONEY
  82. from .types import OID
  83. from .types import REGCLASS
  84. from .types import REGCONFIG
  85. from .types import TIME
  86. from .types import TIMESTAMP
  87. from .types import TSQUERY
  88. from .types import TSVECTOR
  89. # Alias psycopg also as psycopg_async
  90. psycopg_async = type(
  91. "psycopg_async", (ModuleType,), {"dialect": psycopg.dialect_async}
  92. )
  93. base.dialect = dialect = psycopg2.dialect
  94. __all__ = (
  95. "INTEGER",
  96. "BIGINT",
  97. "SMALLINT",
  98. "VARCHAR",
  99. "CHAR",
  100. "TEXT",
  101. "NUMERIC",
  102. "FLOAT",
  103. "REAL",
  104. "INET",
  105. "CIDR",
  106. "CITEXT",
  107. "UUID",
  108. "BIT",
  109. "MACADDR",
  110. "MACADDR8",
  111. "MONEY",
  112. "OID",
  113. "REGCLASS",
  114. "REGCONFIG",
  115. "TSQUERY",
  116. "TSVECTOR",
  117. "DOUBLE_PRECISION",
  118. "TIMESTAMP",
  119. "TIME",
  120. "DATE",
  121. "BYTEA",
  122. "BOOLEAN",
  123. "INTERVAL",
  124. "ARRAY",
  125. "ENUM",
  126. "DOMAIN",
  127. "dialect",
  128. "array",
  129. "HSTORE",
  130. "hstore",
  131. "INT4RANGE",
  132. "INT8RANGE",
  133. "NUMRANGE",
  134. "DATERANGE",
  135. "INT4MULTIRANGE",
  136. "INT8MULTIRANGE",
  137. "NUMMULTIRANGE",
  138. "DATEMULTIRANGE",
  139. "TSVECTOR",
  140. "TSRANGE",
  141. "TSTZRANGE",
  142. "TSMULTIRANGE",
  143. "TSTZMULTIRANGE",
  144. "JSON",
  145. "JSONB",
  146. "JSONPATH",
  147. "Any",
  148. "All",
  149. "DropEnumType",
  150. "DropDomainType",
  151. "CreateDomainType",
  152. "NamedType",
  153. "CreateEnumType",
  154. "ExcludeConstraint",
  155. "Range",
  156. "aggregate_order_by",
  157. "array_agg",
  158. "insert",
  159. "Insert",
  160. )