> ## Documentation Index > Fetch the complete documentation index at: https://domoinc-openapi-sync-dataflows.mintlify.site/llms.txt > Use this file to discover all available pages before exploring further. # PostgreSQL Connector ## Intro PostgreSQL is a widely used open-source relational database management system. You can use Domo's PostgreSQL Connector to pull data from your PostgreSQL database and compile custom reports. To learn more about the PostgreSQL API, see ([https://www.postgresql.org/about/news/postgresql-restful-api-1616/](https://www.postgresql.org/about/news/postgresql-restful-api-1616/ "https://www.postgresql.org/about/news/postgresql-restful-api-1616/") ). You can connect to your PostgreSQL account in the Data Center. This topic discusses the fields and menus that are specific to the PostgreSQL connector user interface. To add DataSets, set update schedules, and edit DataSet information, see [Adding a DataSet Using a Connector](https://domo-support.domo.com/s/article/360042926274?language=en_US "Adding a DataSet Using a Connector"). ## Prerequisites To connect to your PostgreSQL account and create a DataSet, you must have the following: * Username * Password * Host * Port * Select a Certificate Type. The certificate type must match what you enter in the **Certificate** field. If you are unaware of a special certificate, then you can select **No Certificate** from the drop-down list. * Database ## Connecting to Your PostgreSQL Account This section enumerates the options in the **Credentials** and **Details** panes on the PostgreSQL Connector page. The components of the other panes on this page, **Scheduling**, and **Name & Describe Your DataSet**, are universal across most connector types and are discussed in great detail in [Adding a DataSet Using a Connector](https://domo-support.domo.com/s/article/360042926274?language=en_US "Adding a DataSet Using a Connector"). ## Credentials Pane This pane contains fields for entering credentials to connect to your PostgreSQL account. The following table describes what is needed for each field:

Field	Description
Username	Enter your PostgreSQL username. If you don't know your username, contact your PostgreSQL Database Administrator for help.
Password	Enter your PostgreSQL password. If you don't know your password, contact your PostgreSQL Database Administrator for help.
Host	Enter the host name for the SQL database. If you don't know the host name, contact your PostgreSQL Database Administrator for help.
Port	Enter the port number for the SQL database. If you don't know the port number, contact your PostgreSQL Database Administrator for help.
Certificate	Paste the text for your CA certificate or enter the URL where your certificate is located. By default no certificate is required.
Certificate Type	Select a certificate type. This must match what you enter in the Certificate field. If you are not sure of a special certificate, select No certificate from the drop-down list.
Database	Enter the name of the SQL database. If you don't know the database name, contact your SQL Database Administrator.

Once you have entered valid PostgreSQL credentials, you can use the same account any time to create a new PostgreSQL DataSet. You can manage connector accounts in the **Accounts** tab in the Data Center. For more information about this tab, see [Manage Connector Accounts](https://domo-support.domo.com/s/article/360042926054?language=en_US "Manage Connector Accounts"). ## Details Pane

Menu	Description
Query Helper	Edit this query if desired.
Database Tables	Select the database table that you want to view in your report.
Table Columns	Select all the table columns you want to view in your report.
Query Helper	Edit this query if desired.
Incremental Pull	Select either Last Value or Max Value , or None from the drop-down list.

## Other Panes For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see [Adding a DataSet Using a Connector](https://domo-support.domo.com/s/article/360042926274?language=en_US "Adding a DataSet Using a Connector").