> For the complete documentation index, see [llms.txt](https://help.dataimporter.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.dataimporter.io/integrations/database/postgresql.md).

# PostgreSQL

### Configuration

{% hint style="info" %}
You may need to whitelist the Dataimporter [IP Addresses](/security/ip-addresses.md)
{% endhint %}

You will need to enter the following information to create a PostgreSQL Integration:

**Name**\
**Host**\
**Port**\
**Username**\
**Password**\
**Database**

![](https://2845823711-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FtvRVifvxmkDBmPKpGlr2%2Fuploads%2Fth4UOdHsvAR48sY930A9%2FNew%20Postgres.PNG?alt=media\&token=4920aabe-ddff-4c32-af5b-2ffea2cc4fef)

{% hint style="info" %}
Please ensure that these are all entered correctly when creating a connection.
{% endhint %}

### Import

On the Upload screen, you will select which Table you want to Extract, and which Salesforce Object you want to Import into.

<figure><img src="https://2845823711-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FtvRVifvxmkDBmPKpGlr2%2Fuploads%2FKLLqEcsDb2rlE98QMksx%2FPostgres%20Upload.PNG?alt=media&amp;token=22174944-8a08-4f66-9f8d-3fd011a51af1" alt=""><figcaption></figcaption></figure>

### Filtering

On the Clean screen, you will be able to add an SQL Filter, to only Select the records you need as part of the Extraction.

<figure><img src="https://2845823711-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FtvRVifvxmkDBmPKpGlr2%2Fuploads%2FlsExFaafkuCNTj6p787Q%2Fsql%20filter.PNG?alt=media&amp;token=4d4c56d4-7434-4b84-9857-002b1056b51f" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
Column names should be in double quotes, and text values should be in single quotes.
{% endhint %}