Jump to Content
Polytomic
GuidesAPI Reference
Polytomic
GuidesAPI Reference

Introduction

  • Getting started
  • Whitelist IPs
  • SSO/SAML configuration

Creating and maintaining connections

  • Affinity CRM
  • Airtable
  • AWS Athena
  • Azure Cosmos DB
  • Chargebee
  • CSV URL
  • Databricks
  • Dialpad
  • Facebook Ads
  • Google BigQuery
  • Google Sheets
  • Harmonic
  • HTTP API
  • HubSpot
    • Troubleshooting Hubspot sync errors
  • Intercom
  • Iterable
  • Marketo
  • MongoDB
  • MySQL
    • Connecting through SSH
  • Netsuite
  • Pardot
  • Pipedrive
  • PostgreSQL
    • Connecting through SSH
  • Redshift
  • Salesforce
  • Snowflake
  • Stripe
  • Webhooks

Creating source models

  • Creating a SQL model
  • Creating a GSheets model
  • Creating an HTTP API model
    • Using JSON Path for model creation
  • Creating a CSV URL model
  • Tracking fields
  • Joining to other models

Creating a sync

  • Destination types
    • Affinity CRM
    • Google Sheets
    • PostgreSQL
    • Salesforce
  • Choose destination
  • Choose sync type
  • Specify sync mapping
    • Custom text (optional)
    • Sync model filters (optional)
    • Mapping overrides (optional)
  • Specify sync schedule
  • Verify sync summary
  • Force Full Resync

Adding team members

  • User roles
  • Adding a team member

Views

  • About views
  • Setup views

Query runner

  • About query runner

Polytomic API

  • API documentation

On premises

  • On-premises setup
  • Sizing your deployment
  • Changelog
  • Connection-specific setup
    • Airtable
    • Facebook Ad Audiences
    • Front
    • Google Sheets
    • Hubspot
    • Intercom
    • Salesforce
    • Zendesk

PostgreSQL

Source and destination

Suggest Edits
  1. Create a read-only account on your PostgreSQL database. You will supply this account's credentials to Polytomic.

  2. In Polytomic, go to Connections → Add Connection → PostgreSQL.

  3. Enter host and credential details.

PostgreSQL as a destination

Polytomic can write to PostgreSQL. Please refer to the MySQL as a destination page for more information.

Updated 9 months ago


What’s Next
  • Connecting through SSH
  • Table of Contents
    • PostgreSQL as a destination
Copyright © 2022 Polytomic Inc. All rights reserved.    |    Terms of Service    |    Privacy Policy