CODEWITHSUNDEEP
windowspostgresql
matt_3773
matt_3773

Reputation: 73

Postgresql ./psqlrc file directory and file don't exist on Windows 10 local machine

I was having the issue where I needed to turn off the pager to display data in the psql terminal using "\pset pager off". Works like a charm!

Problem is, I have to do it everytime I launch the prompt. I found this fix here - https://pgpedia.info/p/psqlrc.html#:~:text=On%20Windows%2C%20the%20user's%20configuration,%25APPDATA%25%5Cpostgresql%5Cpsqlrc.

The problem with that fix is, the location where ./plqlrc is supposed to exist, doesn't. Has anyone ever dealt with this problem?

The location I am searching for the file is from this link here - https://pgpedia.info/p/psqlrc.html#:~:text=On%20Windows%2C%20the%20user's%20configuration,%25APPDATA%25%5Cpostgresql%5Cpsqlrc.

The file says the path is %APPDATA%\postgresql\psqlrc.conf

I additionally ran the pg_config --sysconfdir and the etc folder it pointed me to also doesn't exist.

The bin and lib are setup correctly in the path as well. Not sure what's going on at this point :)

Any help would be greatly appreaciated!

Thanks in advance!

Upvotes: 0

Views: 253

Answers (1)

user330315
user330315

Reputation:

As documented in the manual the file path on Windows is indeed %APPDATA%\postgresql\psqlrc.conf

The file is not created automatically during installation.

If you need one, then create it. It's a plain text file, so you can create it with any plain text (!) editor (Textpad, Notepad++, VSCode, Vim or even notepad).

Upvotes: 2

Related Questions