Ispirer Website Ispirer Capabilities: PostgreSQL Migration Free Trial

Preserving Source Database Case in Names of Objects for PostgreSQL as Target

Since in PostgreSQL unquoted names are always stored to lower case, to enclose all the identifier names in quotes in target scripts in SQLWays Wizard we can switch on the option, which is responsible for this action:

  • Enable expert mode in the tool
  • Set the option QUOTE_IDENTIFIERS=Always

After that run the conversion.
NOTICE: Since the option is set, the object names will be created in double quotes in PostgreSQL.


If you have any questions or face any difficulties, please contact our support team at support@ispirer.com