leonardBang commented on code in PR #4233:
URL: https://github.com/apache/flink-cdc/pull/4233#discussion_r2719419354
##########
flink-cdc-connect/flink-cdc-pipeline-connectors/flink-cdc-pipeline-connector-postgres/src/main/java/org/apache/flink/cdc/connectors/postgres/utils/PostgresSchemaUtils.java:
##########
@@ -100,6 +102,55 @@ public static Schema getTableSchema(PostgresSourceConfig
sourceConfig, TableId t
}
}
+ public static Map<String,Integer> getColumnOids(PostgresSourceConfig
sourceConfig, TableId tableId,List<String> columns) {
+ try (PostgresConnection jdbc =
getPostgresDialect(sourceConfig).openJdbcConnection()) {
+ Map<String,Integer> oidMaps = new HashMap<>();
+ String inClause = columns.stream()
+ .map(column -> "'" + column.replace("'", "''") + "'")
+ .collect(Collectors.joining(",", "in (", ")"));
+ try {
+ jdbc.query(
+ "SELECT a.attname attname,a.attnum AS age_oid \n" +
+ "FROM pg_attribute a\n" +
+ "JOIN pg_class c ON a.attrelid = c.oid\n" +
Review Comment:
Is the official recommended way to obtain history schema of a Postgres table
?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
