- PostgreSQL 10 Administration Cookbook
- Simon Riggs Gianni Ciolli
- 64字
- 2021-06-25 22:04:21
How it works…
PostgreSQL folds all names to lowercase when used within an SQL statement. Consider this command:
SELECT * FROM mycust;
This is exactly the same as the following command:
SELECT * FROM MYCUST;
It is also exactly the same as this command:
SELECT * FROM MyCust;
However, it is not the same thing as the following command:
SELECT * FROM "MyCust";