Ispirer Website Ispirer Toolkit Overview Free Trial

How to preserve the identifiers names case when migration to PostgreSQL

Please note, that in PostgreSQL unquoted names are always folded to lower case:
https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS
To enclose all the identifier names in quotes in target scripts you need to set the option “Quote identifiers=Always”, the way it is done on the screenshot:

After that save the changes and run the conversion. Also take a note that since you use this option, you should use the object names in double quotes in PostgreSQL.

If you have any other questions, please feel free to mail us : support@ispirer.com


© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.