Skip to main content

About the PostgreSQL collector

Use this collector to harvest metadata for PostgreSQL tables and columns across the enterprise systems and make it searchable and discoverable in


The latest version of the Collector is 2.159. To view the release notes for this version and all previous versions, please go here.

What is cataloged

The collector catalogs the following information.

Table 1.


Information cataloged


Name, Description, JDBC type, Column Type, Is Nullable, Default Value, Key type (Primary, foreign), column size, column index


Name, description, primary key, schema


Name, description, SQL definition




Type, name, identifier, server, port, environment, JDBC URL


Name, Description, Function Type

Stored Procedure

Name, Description, Stored Procedure Type

Relationships between objects

By default, the harvested metadata includes catalog pages for the following resource types. Each catalog page has a relationship to the other related resource types. If the metadata presentation for this data source has been customized with the help of the Solutions team, you may see other resource pages and relationships.

Table 1.

Resource page






Lineage for PostgreSQL

The collector identifies, for every column in a View, the column(s) in other tables or views from which that view’s column selects (sources) its data.

The collector traces these relationships from a View’s columns to ultimate source Table columns across SQL expressions and subqueries.

Additionally, the collector establishes relationships between a View and any columns in source Tables that sort the rows in the View (via SQL ORDER BY), filter the rows in the View (via SQL WHERE and HAVING clauses), and aggregate the rows in the View (via SQL GROUP BY).


Note that the collector currently does not establish view-to-table relationships in the JDBC collectors. This can be done transitively (e.g., in SPARQL) by noting the column-level relationships, since each column is associated with one and only one table or view.

Authentication supported

  • The collector supports basic authentication to PostgreSQL.