Help Center> Database and Application Migration UGO> User Guide> Object Migration> Converting Syntax> Converting Syntax from PostgreSQL to GaussDB
Updated on 2024-05-28 GMT+08:00
View PDF

Converting Syntax from PostgreSQL to GaussDB

Constraints on the GaussDB Modes

Mode compatibility:

  • PostgreSQL can be migrated to GaussDB (O mode).
  • In GaussDB (O mode), an empty string is stored as NULL. After select '' is null; is executed, the result is True. It is the same as that in Oracle.

Impact Scope

  • If the source database is PostgreSQL and the target database is GaussDB (O mode), SQL statements involving empty character strings or NULL syntax need to be adapted and reconstructed.
  • The impact scope includes DML, DDL, and system functions, such as select'' is null; and select regexp_matches('test1', 'test1', '');.
  • UGO can evaluate the IS NULL syntax and empty string syntax during the migration from PostgreSQL to GaussDB.
Parent topic: Converting Syntax