{"revision":"c10276e953456835cdbb1f3a60d58ae1980be353","document":{"id":22008,"path":"integrate-applications/postgresql-zcc.md","title":"PostgreSQL","bundle":null,"doc_type":null,"release":"australia","body":"\n# PostgreSQL\n\nThe PostgreSQL connector enables access to relational database data from your PostgreSQL instance without moving or copying data.\n\nConnection admins set up connections to PostgreSQL in the Zero Copy Connector Hub and grant data stewards access. Data stewards use the connection to create data fabric tables and map data from PostgreSQL. Users can then access PostgreSQL data through the table list view or GlideRecord scripts. For details, see [Managing data fabric tables](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/integrate-applications/managing-data-fabric-tables-zcc.md).\n\nFor specific functionality limitations, see [Primary Connectors Limitations \\(KBB0010487\\)](https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KBB0010487).\n\nThe connector supports primary key and composite \\(unique\\) key detection on PostgreSQL tables.\n\nThe connector supports pushdown for the following Glide queries and list view operations, allowing most queries to execute at the data source:\n\n-   Sort\n-   Limit\n-   Offset\n-   Filter\n-   GroupBy\n-   avg\\(\\)\n-   count\\(\\)\n-   max\\(\\)\n-   min\\(\\)\n-   sum\\(\\)\n-   References\n\nThe connector also supports the following statistical aggregate pushdowns: `STDDEV_SAMP`, `STDDEV_POP`, `VARIANCE_SAMP`, `VARIANCE_POP`, `COVAR_SAMP`, `COVAR_POP`, `CORR`, `REGR_INTERCEPT`, and `REGR_SLOPE`. The connector also supports complex-expression pushdown, including arithmetic operations, `CAST`, `AND`/`OR`, `IN`, and `LIKE`.\n\n## Supported data types\n\n**Note:** The following PostgreSQL data types aren't supported: `BYTEA`, `UUID`, `JSON`, `JSONB`, `VECTOR`, `HSTORE`, `ARRAY`, `GEOMETRY`, `GEOMETRY(GEOMETRY TYPE, SRID)`, and `POINT`.\n\n|PostgreSQL|Data fabric table|\n|----------|-----------------|\n|bit|True/False|\n|boolean|True/False|\n|smallint|Integer|\n|integer|Integer|\n|bigint|Long|\n|real|Floating Point Number|\n|double|Floating Point Number|\n|numeric\\(p, s\\)|Decimal|\n|decimal\\(p', s'\\)|Decimal|\n|numeric \\(unconstrained\\)|Decimal|\n|char\\(n\\)|Char \\(fixed-length character field\\)|\n|varchar\\(n\\)|String \\(variable-length character field\\)|\n|enum|String|\n|date|Date|\n|time\\(n\\)|Basic Time|\n|timestamp\\(n\\)|Basic Date/Time|\n|timestampz\\(n\\)|Date/Time|\n|money|String|\n\n**Related topics**  \n\n\n[Create a PostgreSQL connection](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/integrate-applications/create-postgresql-connection-zcc.md)\n\n"}}