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
- Create a new data source.
- 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):
- Hostname or IP address
- Port (Optional)
- Click Authenticate.
- 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.
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:
- 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.
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: