You can use the PostgreSQL catalog source to extract metadata from a PostgreSQL source system.
PostgreSQL is an open-source relational database management system (RDBMS) used as a data store or data warehouse for applications.
Extracted metadata
You can extract specific metadata from a PostgreSQL source system with a PostgreSQL catalog source.
Metadata Command Center extracts the following objects from a PostgreSQL source system:
•Database
•Foreign Table
Note:
Objects of the Foreign Table type appear as Table in Data Governance and Catalog.
•Schema
•Table
•View
•Materialized View
Note:
Objects of the Materialized View type appear as View in Data Governance and Catalog.
•Stored Procedure
Data profiling for PostgreSQL objects
Configure data profiling to run profiles on the metadata extracted from a PostgreSQL source system. You can view the profiling statistics in Data Governance and Catalog.
You can run data profiles on the following PostgreSQL objects:
•Tables
•Views
The data profiling task runs profiles on the following data types:
PostgreSQL Data Type
Transformation Data Type
Description
Bigint/int8
Bigint
Precision 19, scale 0
Bigserial/Serial8
BigInt
Precision 19, scale 0
Boolean
String
Precision 6
Bytea
Binary
Precision 104857600
Char
String
Precision 1
Char(n)
String(n)
n<=10485760
Citext
Text
Precision 104857600
Date
Date/Time
Precision 29, scale 9
Decimal
Decimal
Precision 1 to 28, scale 0 to 28
Double/Float8
Double
Precision 15, scale 0
Int/Int4
Integer
Precision 10, scale 0
Numeric
Decimal
Precision 1 to 28, scale 0 to 28
Real/Float4
Double
Precision 15, scale 0
Serial
Integer
Precision 10, scale 0
Smallint/Int2
Integer
Precision 10, scale 0
Smallserial/Int2
Integer
Precision 10, scale 0
Text
String
Precision 104857600
Time
Date/Time
Precision 29, scale 9
Timestamp
Date/Time
Precision 29, scale 9
Timestamp with time zone
Date/Time
Precision 29, scale 9
Timestamp without time zone
Date/Time
Precision 29, scale 9
Varchar
String
Precision 104857600
Varchar(n)
String(n)
n <=10485760
Compatible connectors
Before you configure a PostgreSQL catalog source, you must connect to the PostgreSQL source system.
Use the PostgreSQL connector to connect to the PostgreSQL source system.
For information about configuring a connection, see Connections.