add typarray column in pg_catalog.pg_type

[fuyufjh]

Is your feature request related to a problem? Please describe.

Used in https://github.com/psycopg/psycopg2/blob/68d786b610dc18bd9201fa65bc8be541b3d16386/lib/extras.py#L907

Describe the solution you'd like

No response

Describe alternatives you've considered

No response

Additional context

No response

[fuyufjh]

The typarray field in pg_catalog.pg_type refers to the type of its associated array type. For example, here are the rows of type integer and integer[].

dev=# select oid, typname, typname, typelem, typarray, typsend, typreceive from pg_type where oid in (23, 1007);
 oid  | typname | typname | typelem | typarray |  typsend   | typreceive
------+---------+---------+---------+----------+------------+------------
   23 | int4    | int4    |       0 |     1007 | int4send   | int4recv
 1007 | _int4   | _int4   |      23 |        0 | array_send | array_recv
(2 rows)

Whenever a user-defined type is created, PostgreSQL automatically creates an associated array type, whose name consists of the element type's name prepended with an underscore

Unfortunately, these associated array types do not exist in RisingWave. I can hardly find a reasonable way to mock that.

---

IMPORTANT NOTES: If you run into this problem when using sqlalchemy, please use https://github.com/risingwavelabs/sqlalchemy-risingwave as a substitute for the PG native plugin.