You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository was archived by the owner on Jun 4, 2024. It is now read-only.
In PgSQL, if a table is created with camel case (or other way in which case of all chars is not same) column name e.g. firstName without the quotes then it is case insensitive and is converted to e.g. firstname
In order to make it case-sensitive, column name should be quoted "firstName" everywhere it is used.
However this is not same in MySQL.
The text was updated successfully, but these errors were encountered:
-- Mysql will say error: #1060 - Duplicate column name 'firstname'CREATETABLE `tmp_table_2_` (
`firstName`varchar(255) NOT NULL,
`firstname`varchar(255) NOT NULL
)
-- Pgsql will run this successfullyCREATETABLE `tmp_table_2_` (
"firstName"varchar(255) NOT NULL,
"firstname"varchar(255) NOT NULL
)
In PgSQL, if a table is created with camel case (or other way in which case of all chars is not same) column name e.g.
firstName
without the quotes then it is case insensitive and is converted to e.g.firstname
In order to make it case-sensitive, column name should be quoted
"firstName"
everywhere it is used.However this is not same in MySQL.
The text was updated successfully, but these errors were encountered: