I am a newbie in SQL world and I am just getting accuanted with the database functionality in Intellij IDEA. I was informed that "there may be some reserved words in PostgreSQL dialect", for instance "name", and I should put them in double quatation marks (please, see the picture below):
However, when I remove them, IDEA does not identify an error, just change the word's color. I am not aware if the functionality changes when I do so:
Please, could you advise me if there are any words in Intellij IDEA (PostgreSQL dialect) that require special treatment, such as double quatation marks etc.
Thanks in advance for your help.