> ## Documentation Index
> Fetch the complete documentation index at: https://docs.datazone.co/llms.txt
> Use this file to discover all available pages before exploring further.

# PostgreSQL

> PostgreSQL is a powerful, open source object-relational database system.

# Overview

PostgreSQL is an advanced open-source relational database that supports both SQL (relational) and JSON (non-relational) querying. Datazone provides native integration with PostgreSQL databases, allowing you to easily connect and extract data from your PostgreSQL instances.

## Connection Parameters

| Parameter     | Required | Description                                                          |
| ------------- | -------- | -------------------------------------------------------------------- |
| Name          | Yes      | A unique identifier for your PostgreSQL source                       |
| Host          | Yes      | The hostname or IP address of your PostgreSQL server                 |
| Port          | Yes      | The port number on which PostgreSQL is running (default: 5432)       |
| Database Name | Yes      | The name of the database you want to connect to                      |
| Schema Name   | No       | Optional schema name (if different from the default 'public' schema) |
| User          | Yes      | Username with appropriate permissions to access the database         |
| Password      | Yes      | Password for the specified user                                      |

## Required Permissions

The PostgreSQL user account needs the following permissions:

* `SELECT` - For reading data from tables
* `USAGE` - For accessing schemas
* `CONNECT` - For connecting to the database

## Limitations

Be aware of the following limitations when working with PostgreSQL sources:

* Supported PostgreSQL versions: 9.6 and above
* Some PostgreSQL-specific types will be converted to standard types

## Next Steps

After configuring your PostgreSQL source:

1. Create extracts to specify which tables to ingest
2. Configure scheduling for recurring extracts
3. Integrate the source into your data pipelines

For more information about working with extracts and pipelines, refer to their respective documentation sections.