Working with data in the PostgreSQL database

After you collect data using the Reports feature, you can access that data and use it as input to your business intelligence software.

Use the procedures below to connect to the database, then retrieve data using SQL statements. For example, you can use the SELECT statement to query data or the COPY statement to export data.

  • You don't have to follow this procedure if you use Data Transmitters.

For more information about working with data in the PostgreSQL database, see the PostgreSQL tutorial (