Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Simple question, but utterly infuriating. Trying to use psql from a command prompt, but can't access any of the previous commands with the up/down cursors. I could also really do with finding out where the postgress equivalent to .bash_history is.

Just tried \s and had a "history is not supported by this installation" error.

Sorry, I should have said I was running on Windows. I'm not sure there is an equivalent to .bash_history, but if there was, that would be fantastic, as I could read the command history from there.

share|improve this question
What platform are you on? And how did you install PostgreSQL exactly? – Craig Ringer Feb 26 '14 at 12:10
I'm guessing you're on Windows? – Colin 't Hart Feb 26 '14 at 12:58
@ypercube Does he mean "command prompt windows" or "Windows" the OS? His reference to .bash_history is confusing, whereas he talks about "command prompt" and not "shell". – Colin 't Hart Feb 26 '14 at 13:01
Yeah, I noticed the bash, too (and removed the comment.) – ypercubeᵀᴹ Feb 26 '14 at 13:11
Have you tried PowerShell? – Neil McGuigan Feb 26 '14 at 19:07

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.