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.