[FLINK-15351] develop PostgresCatalog to connect Flink with Postgres tables and ecosystem

• Type: New Feature
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Fix Version/s: 2.0.0
• Component/s: Connectors / JDBC
• Labels: auto-deprioritized-major auto-unassigned
• Assignee: Unassigned
• Reporter: Bowen Li
• Created: 21/Dec/19 00:01
• Updated: 10/Jul/24 06:58

Issue Links

• Is contained by: FLINK-15350 develop JDBC catalogs to connect to relational databases

Sub-Tasks

• develop PostgresCatalog: Closed
• support precision of timestamp and time data types: Closed
• add documentation for JDBCCatalog and PostgresCatalog: Closed
• connect PostgresCatalog to table planner: Closed
• add back PostgresCatalogITCase: Closed
• support array types in PostgresRowConverter: Closed
• add e2e tests for reading primitive data types from postgres with JDBCTableSource and PostgresCatalog: Closed
• support reading timestamp, data, and time in JDBCTableSource: Closed
• add e2e tests for reading array data types from postgres with JDBCTableSource and PostgresCatalog: Open
• Support serial field type in PostgresCatalog: Closed
• Pass table's primary key to catalog table in PostgresCatalog: Closed
• Implement listViews: Open
• Remove useless switch for decimal in PostresCatalog: Closed