Sample Header Ad - 728x90

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