Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ora2pg does not convert anydata #1642

Open
did16 opened this issue Jun 10, 2023 · 1 comment
Open

ora2pg does not convert anydata #1642

did16 opened this issue Jun 10, 2023 · 1 comment

Comments

@did16
Copy link

did16 commented Jun 10, 2023

Ora2Pg v23.2 does not convert Oracle Anydata type to PostgreSQL:
--- Oracle
CREATE TABLE "CTR"."TQ_ACTIV"
( ...
"USER_PROP" "SYS"."ANYDATA" ,
...
--- PostgreSQL
CREATE TABLE tq_activ (
...
user_prop ANYDATA

anydata is not a postgresql type

@darold
Copy link
Owner

darold commented Jun 16, 2023

Right, converting this depend of the use but such all-in-one data type do not exists in PostgreSQL. Some are converting it to json but my opinion is that an extension should be developed to emulate this datatype. The other solution is to modify the application logic and design to avoid the use of such insane column.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants