:tocdepth: 3

:py:mod:`gws.plugin.postgres.provider`
======================================

.. py:module:: gws.plugin.postgres.provider

.. autoapi-nested-parse::

   Postgres database provider.



**Source code:** :source:`gws.plugin.postgres.provider<gws/plugin/postgres/provider.py>`



Module Contents
---------------



.. py:class:: Config


   Bases: :py:obj:`gws.base.database.provider.Config`

   Postgres/Postgis database provider

   .. py:attribute:: database
      :type:  Optional[str]

      Database name.

   .. py:attribute:: host
      :type:  Optional[str]

      Database host.

   .. py:attribute:: options
      :type:  Optional[dict]

      Libpq connection options.

   .. py:attribute:: password
      :type:  Optional[str]

      Password.

   .. py:attribute:: port
      :type:  int
      :value: 5432


      Database port.

   .. py:attribute:: serviceName
      :type:  Optional[str]

      Service name from pg_services file.

   .. py:attribute:: username
      :type:  Optional[str]

      Username.


.. py:function:: connection_url(cfg: gws.Config)

.. py:class:: Object


   Bases: :py:obj:`gws.base.database.provider.Object`

   .. py:method:: describe_column(table, column_name)

   .. py:method:: join_table_name(schema, name)

   .. py:method:: split_table_name(table_name)

   .. py:method:: table_bounds(table)

   .. py:method:: url()