4 ms·
> For example, I have preferred FirstName or even “[First Name]” instead of first_name in sql Do not do this in Postgres, it will be a pain in the ass since yo
by matte_black 9y ago
> For example, I have preferred FirstName or even “[First Name]” instead of first_name in sql
Do not do this in Postgres, it will be a pain in the ass since you will have to use quotes around everything.
- cryptonector 9y agoRight. PG has appropriated square brackets for array notations, so you really just have to use double-quotes. At least PG tries really hard to not add new reserved keywords, which means you mostly don't have to worry about your schema element names possibly conflicting with new keywords in future releases.