Function JSON_ARRAYAGG does not get translated properly

darold / ora2pg

Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.

http://www.ora2pg.com/

GNU General Public License v3.0

978 stars 341 forks source link

Function JSON_ARRAYAGG does not get translated properly #1692

Closed shubham-yb closed 5 months ago

shubham-yb commented 9 months ago

Hi Team,

The Oracle function JSON_ARRAYAGG is not supported by PG and Ora2pg dumps it as is. PG equivalent of this function is the JSON_AGG function. Can we please add this function mapping.

Thank You for your help!

darold commented 5 months ago

The json_arrayagg() function is supported in PG 16, I have no plan to support the translation of this function for older version. Sorry.