public List<Map<String, Object>> getTableColumnsMetaData(String schema, String table) {
        try {
            String query = "SELECT ordinal_position, tab_columns.column_name, data_type, character_maximum_length,\n"
                    + "numeric_precision, is_nullable, tab_constraints.constraint_type,\n"
                    + "col_constraints.constraint_name,col_check_constraints.check_clause\n"
                    + "FROM information_schema.columns AS tab_columns\n"
                    + "LEFT OUTER JOIN\n"
                    + "information_schema.constraint_column_usage AS col_constraints\n"
                    + "ON tab_columns.table_name = col_constraints.table_name AND\n"
                    + "tab_columns.column_name = col_constraints.column_name\n"
                    + "LEFT OUTER JOIN\n"
                    + "information_schema.table_constraints AS tab_constraints\n"
                    + "ON tab_constraints.constraint_name = col_constraints.constraint_name\n"
                    + "LEFT OUTER JOIN\n"
                    + "information_schema.check_constraints AS col_check_constraints\n"
                    + "ON col_check_constraints.constraint_name = tab_constraints.constraint_name\n"
                    + "WHERE tab_columns.table_schema = ? \n"
                    + "AND tab_columns.table_name = ? \n"
                    + "ORDER BY ordinal_position";
            if (LOG.isDebugEnabled()) {
                LOG.debug(String.format("Executing query '%s'", query));
            }
            return executeQuery(query, schema, table);
        } catch (ClassNotFoundException se) {
            throw new IllegalArgumentException("Failed to find jdbc driver." + se.getMessage(), se);
        } catch (SQLException se) {
            throw new IllegalArgumentException("Failed to get table schema info from StarRocks. " + se.getMessage(),
                    se);
        }
    }
query PostgreSQL table meta data, such as column name, data type, constraint type, etc.

@param schema
@param table
@return
inlong-sort/sort-flink/sort-flink-v1.13/sort-connectors/postgres-cdc/src/main/java/org/apache/inlong/sort/cdc/postgres/manager/PostgreSQLQueryVisitor.java