Ispirer Home Page Ispirer SQLWays Migration Product Page Request SQLWays

How to preserve the identifier names case in PostgreSQL?

Please note that in PostgreSQL all identifier names folded to lower case unless they are enclosed in double quotes: https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS 

To preserve the indentifier name case when migrating to PostgreSQL database, you  enclose the identifier names in double quotes in the Sqlways Wizard tool, you need to:

  1. On the “Specify DDL and data options” page you need:
    1. to click on the “Database” tab
    2. to click on the “Name” tab
    3. to set “Quoters identifiers = Always”



Ispirer Home Page Ispirer SQLWays Migration Product Page Request SQLWays


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