Search
Clear search
Close search
Google apps
Main menu

PostgreSQL connector

PostgreSQL is an open source relational database management system developed by a worldwide team of volunteers. 

The PostgreSQL connector allows you to access data from PostgreSQL based databases within Data Studio. This connector uses the PostgreSQL JDBC driver to connect a Data Studio data source to a single PostgreSQL database table.

In this article:

How to connect to PostgreSQL

  1. Create a new data source.
  2. Enter your database authentication information (either by filling in the fields in the BASIC tab, or by entering a completed JDBC URL in the JDBC URL tab): 
    1. Hostname or IP address
    2. Port (Optional)
    3. Database
    4. Username
    5. Password
  3. Click Authenticate.
  4. Select a table from the list and click CONNECT.

You will then see the columns in the selected table as fields, which you can now use in your reports.

Supported data types

The PostgreSQL connector currently supports the following data types:

  • Numeric
  • Character
  • Boolean
  • Date/Time (except Intervals)

When Data Studio encounters a column of a non-supported type, it will not create a field for that column.

Learn more about PostgreSQL data types.

Notes

Currently this connector does not support SSL. Be careful with the data you send.

If you database is behind a firewall, you will need to open access to the following IP addresses so that Data Studio can access your database:

64.18.0.0/20

64.233.160.0/19

66.102.0.0/20

66.249.80.0/20

72.14.192.0/18

74.125.0.0/16

108.177.8.0/21

173.194.0.0/16

207.126.144.0/20

209.85.128.0/17

216.58.192.0/19

216.239.32.0/19

Create a data source

Was this article helpful?
How can we improve it?
What's new in Data Studio

Learn about new features and recent changes.