SQL – HINT to reference a column

When you imported this “Northwind” database column names were imported in CamelCase – your import must’ve added double quotes to column identifiers to create table queries.

This is rather unfortunate, as this would cause that you’d have to quote them also in all queries, like:

select "City" from customers;

To remain sane I’d suggest you to rename all columns to lower case. This way it wouldn’t matter what case you use, as Postgres converts all unquoted identifiers to lower case automatically. Then any of this would work:

select city from customers;
select City from Customers;
SELECT CITY FROM CUSTOMERS;

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)