Phiona Documentation
  • 👋Introduction
  • 🛣️The Basics
    • How Phiona Works
    • Scheduling & Automation
    • API Documentation
  • 🔗Data Sources
    • Airtable
    • Amazon S3
    • BigCommerce
    • BigQuery
    • Dropbox
    • Firebase
    • Google Analytics v4
    • Google Drive
    • Google Search Console
    • Google Sheets
    • Hubspot
    • Import from API (Beta)
    • Local Files
    • MongoDB
    • MySQL
    • PostgreSQL
    • Redshift (Beta)
    • Shopify
    • Snowflake (Beta)
    • WooCommerce
    • Wordpress
  • 📈Sharing Data
    • Share Project with Collaborators
    • Share Public Project Link
    • Share Serverless SQL Warehouse
    • Build API Endpoint From Single Dataset
    • Share Dataset via Email
  • 🛠️Clean & Transform
    • Supported Data Types & Column Header Functions
    • Supported Clean Functions
    • Supported Transformations
    • Applying Existing or Shared Blueprints
  • 🌆Export Destinations
    • Airtable
    • Amazon S3
    • Dropbox
    • Google Drive
    • Google Sheets
    • MongoDB
    • MySQL
    • PostgreSQL
    • Redshift (Beta)
    • Snowflake (Beta)
  • Changelog
Powered by GitBook
On this page

Was this helpful?

  1. Data Sources

PostgreSQL

PreviousMySQLNextRedshift (Beta)

Last updated 3 years ago

Was this helpful?

Phiona supports connections to PostgreSQL databases. When you first click on either of the two buttons, you will see all of the current connections you have made to databases. Click on the "Create a new connection" link on the top right and fill in the relevant database details.

Please make sure you are allowed at least read access to this database by your organization.

If successful, you'll see a database link when you next open your PostgreSQL connection page.

🔗
Click on the PostgreSQL button to connect
Enter your database details to set up the connection
A successfully connected PostgreSQL database