|
<< Click to Display Table of Contents >> Navigation: Connectors > PostgreSQL > Tables and Views |
The DTS PostgreSQL Connector fully supports all tables and views in the PostgreSQL database and does not differentiate between the two.
DTS Name |
<table_or_view_name> |
DTS Key |
<schema_name>.<table_or_view_name> |
The connector is also capable of extracting metadata regarding the table/view columns:
▪DATA_TYPE
▪UDT_NAME
▪NUMERIC_PRECISION
▪NUMERIC_SCALE
▪IS_NULLABLE
▪COLUMN_DEFAULT
▪CHAR_LENGTH
▪CHARACTER_OCTET_LENGTH
▪CONSTRAINT -> PRIMARY KEY
▪CONSTRAINT -> FOREIGN_KEY
Standard functionality only makes use of DATA_TYPE, UDT_NAME and PRIMARY_KEY, but the other items are available for extension in DTS descriptor objects.