Persistent PROMPT with psql

Salvatore De Paolis writes:
there's a way to set persistently the PROMPT1 and/or PROMPT2 variables?
I didn't find anything about this in man pages, i can change them once in
psql, but the changes are lost once i quit.

On Sun, 13 Jun 2010 22:05:07 -0400 Tom Lane wrote:



You can set them in your ~/.psqlrc file.

regards, tom lane