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.

Custom Query

Select the CUSTOM QUERY option to provide a SQL query instead of connecting to a single table. Data Studio uses this custom SQL as an inner select statement for each generated query to the database.

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

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.