disable autocommit in PostgreSQL 13 on Oracle Linux 8
0
votes
1
answer
1268
views
I know this question has been asked before. I am new to PostgreSQL and would like to turn off "autocommit" forever. After some research, I need to add "\set AUTOCOMMIT off" in the ~/.psqlrc file. Where do I find this file ~/.psqlrc? in directory /var/lib/pgsql/13/data/ I do not find it. I created it "vi ~/.psqlrc" and inserted the command \set AUTOCOMMIT, but it did not work. What is missing here? I would be very happy about any tip.
Many greetings, Ahmed
Asked by Ahmed Aldam
(3 rep)
Jun 16, 2022, 09:10 AM
Last activity: Jun 16, 2022, 10:28 AM
Last activity: Jun 16, 2022, 10:28 AM