Cannot change datestyle intellij IDE

Question

I want to change datestyle from 'ISO, MDA' to 'ISO, DMA'. I execute this command in intellij postegresql console :

SET datestyle = "ISO, DMY"; 

It changes the datestyle but temporary; when trying to check it in another terminal it returns to 'ISO, MDA'

Thanks for help

Answer 1

To make the datestyle change permanent, add it to the postgresql.conf file:

 datestyle = 'iso, dmy'

Check this answer if you need to locate the conf file.