---
sourceDocument: Australia Workflow Data Fabric
sourceDocumentLink: https://www.servicenow.com/docs/r/australia/integrate-applications

 Release :

    - australia

ft:locale :

    - en-US

ft:publication_title :

    - Australia Workflow Data Fabric

ft:clusterId :

    - crint

bundleId :

    - crint

workflow :

    - Creator


---

# PostgreSQL

# PostgreSQL {#ariaid-title1}

Release version: Australia  
Updated March 12, 2026  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read  
The PostgreSQL connector enables access to relational database data from your PostgreSQL instance without moving or copying data.

Connection 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://www.servicenow.com/docs/vdLJlIcLw1vrKjAsL1R1Eg "Access data virtually from an external source or a local table on your instance using data fabric tables.").{#postgresql-zcc__postgresql-zcc-para-1}

For specific functionality limitations, see [Workflow Data Fabric - Primary Connectors Limitations \[KBB0010487\]](https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KBB0010487).{#postgresql-zcc__postgresql-zcc-para-2}

The connector supports primary key and composite (unique) key detection on PostgreSQL tables.{#postgresql-zcc__postgresql-zcc-para-3}

The connector supports pushdown for the following Glide queries and list view operations, allowing most queries to execute at the data source:{#postgresql-zcc__postgresql-zcc-para-4}

* Sort
* Limit
* Offset
* Filter
* GroupBy
* avg()
* count()
* max()
* min()
* sum()
* References

{#postgresql-zcc__ul_pg_pushdowns}

The 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`.{#postgresql-zcc__postgresql-zcc-para-5}

## Supported data types {#postgresql-zcc__section_data_types}

Note:  
The following PostgreSQL data types aren't supported: `BYTEA`, `UUID`, `JSON`, `JSONB`, `VECTOR`, `HSTORE`, `ARRAY`, `GEOMETRY`, `GEOMETRY(GEOMETRY TYPE, SRID)`, and `POINT`.  
{#postgresql-zcc__table_pg_datatypes__entry__2}

| PostgreSQL | Data fabric table |
|-|-|
| bit | True/False |
| boolean | True/False |
| smallint | Integer |
| integer | Integer |
| bigint | Long |
| real | Floating Point Number |
| double | Floating Point Number |
| numeric(p, s) | Decimal |
| decimal(p', s') | Decimal |
| numeric (unconstrained) | Decimal |
| char(n) | Char (fixed-length character field) |
| varchar(n) | String (variable-length character field) |
| enum | String |
| date | Date |
| time(n) | Basic Time |
| timestamp(n) | Basic Date/Time |
| timestampz(n) | Date/Time |
| money | String |
[Table 1. Data type mapping]

{#postgresql-zcc__table_pg_datatypes}
**Related tasks**   

* [Create a PostgreSQL connection](https://www.servicenow.com/docs/RvCWI4o6qReBtHzYtIOh_Q "Create a zero-copy connection to PostgreSQL to access relational database data in Zero Copy Connector Hub without moving or duplicating data.")