Syncing 10,000 leads/mo? Get a demo
LeadsBridge
Sign up for free
PostgreSQL logo

How to connect PostgreSQL with LeadsBridge

SIGN UP FOR FREE

Integrate PostgreSQL with LeadsBridge

PostgreSQL is an open source database, more specifically, its an object-relational database

PostgreSQL is an open source database, more specifically, it's an object-relational database management system with an emphasis on extensibility and standards compliance.

In this article, you'll learn how to connect your LeadsBridge account with PostgreSQL.

Connect PostgreSQL integration

  1. Head over to the left sidebar and click on Integrations
  2. Click on the Add New button
  3. Enter a recognizable name for your integration
  4. Click on the Browse button
  5. Select "PostgreSQL" from the providers list
  6. Click on the Next button
  7. Enter Database host, Database name, Username, Password, Charset and Database Schema (Optional) to connect PostgreSQL with LeadsBridge
  8. Click on the Finish button

Which entity concepts we support for PostgreSQL

  1. Row

    A row is a series of data banks laid out horizontally in a table or spreadsheet.

Which segmentation concepts we support for PostgreSQL

With LeadsBridge you may use these segmentation concept for PostgreSQL.

  1. Table

    A table presents the data as a table composed of rows and columns and is used to see the details and compare the values.
 

Common questions for PostgreSQL

What are the LeadsBridge IPs that need to be whitelisted?

To connect your PostgreSQL database you should whitelist LeadsBridge IPs, you can find them on the following link: ( Read from PostgreSQL docs)

How can I add my table database schema?

If you get the following error message:
  • Undefined table: 7 ERROR: relation "table name" does not exist
Means that we were not able to find your table in the default database schema, in order to fix this you should:
  1. Go to Integrations and open your PostgreSQL integration setup
  2. Type your table database schema inside Database Schema (Optional)
  3. Finally, click on Finish to save your changes

If you have any further questions regarding this matter, or if you need help to set up the connection between PostgreSQL with LeadsBridge, do not hesitate to get in touch!