Test more pg-types of postgres-cdc

[KeXiangWang]

Like enum, some of the postgres rows cannot be directly parsed by String. We need more tests to verify different types.
#16423 (comment)

[StrikeW]

More context: in cdc backfill we use Rust client to scan the upstream table, and we need to covert those rows in postgres format into our OwnedRow to store in our storage.
For data types not supported in RW we will fallback to VARCHAR, which is supported in the DebeziumJson parser but need additional work to handle the format conversion in cdc backfill. Note that this requirement also apply to other cdc connector support cdc-backfill, e.g. mysql-cdc. cc @fuyufjh

[StrikeW]

We can create a cdc backfill table in

risingwave/integration_tests/postgres-cdc/compatibility-rw.sql

Line 2 in adf1341

CREATE TABLE IF NOT EXISTS postgres_all_types(

to cover the data type test.

[KeXiangWang]

We can create a cdc backfill table in

Okk I can add this.

[github-actions]

This issue has been open for 60 days with no activity.

If you think it is still relevant today, and needs to be done in the near future, you can comment to update the status, or just manually remove the no-issue-activity label.

You can also confidently close this issue as not planned to keep our backlog clean.
Don't worry if you think the issue is still valuable to continue in the future.
It's searchable and can be reopened when it's time. 😄

[KeXiangWang]

Done in

risingwave/e2e_test/source/cdc/postgres_cdc.sql

Line 41 in 20699d4

CREATE TABLE IF NOT EXISTS postgres_all_types(