Home：ALL Converter>CLOB in Postgresql

CLOB in Postgresql

Ask Time：2021-05-11T18:05:11         Author：javauser35

Json Formatter

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?

Author:javauser35，eproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article：https://stackoverflow.com/questions/67484575/clob-in-postgresql
Shelby Carpenter :
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.",
2021-10-01T21:39:11

More about “CLOB in Postgresql” related questions

热门文章热门文章

相关搜索

yy

网站导航

特色功能

软件已通过杀毒认证

软件已通过杀毒认证_转转大师PDF转换器

联系方式

转转大师扫我联系客服_转转大师PDF转换器

转转大师扫我联系客服

Copyright Reserved 2009- © AllConverter.Net