CLOB in Postgresql

Question

I'm trying to migrate from Oracle to Postgresql database.

I have some clob column types at Oracle DB:

Here is my questions.

1. Is the TEXT type equivelant for the CLOB in ORACLE DB?

2. Are there any risk for directly convert it to the TEXT? I think TEXT limit is 1gb for the POSTGRE and CLOB limit is 4GB in Oracle?

Answer 1

Yes, TEXT is a good equivalent in PostgreSQL to CLOB in Oracle. But max size for TEXT is roughly 1GB whereas max for CLOB is 4GB.