Sihem Hcine
Sihem Hcine

Reputation: 1129

Cannot change datestyle intellij IDE

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

Upvotes: 0

Views: 74

Answers (1)

Bajal
Bajal

Reputation: 6006

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.

Upvotes: 1

Related Questions