Help Center/ Database and Application Migration UGO/ User Guide/ Syntax Conversion/ Syntax Conversion/ From PostgreSQL to GaussDB
Updated on 2025-06-07 GMT+08:00
View PDF
Share

From PostgreSQL to GaussDB

Compatibility:

  • Migration from PostgreSQL to GaussDB (Oracle-compatible mode)
  • In an Oracle-compatible GaussDB database, an empty string is stored as null. If True is returned in the result after select '' is null; is executed, an empty string is also stored as null in the Oracle database.

Impact:

  • If the source database type is PostgreSQL and the target database type is GaussDB (Oracle-compatible mode), SQL statements containing empty character strings or null need to be refactored.
  • DML operations, DDL operations, and system functions will be affected, such as select'' is null; and select regexp_matches('test1', 'test1', '');.
  • UGO can evaluate the IS NULL syntax and empty string syntax during migration from PostgreSQL to GaussDB.
Parent topic: Syntax Conversion