Thread: Persistent PROMPT with psql

Hi,

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.

regards
S.

Salvatore De Paolis <iwkse@gmx.com> 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.

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

            regards, tom lane

On Sun, 13 Jun 2010 22:05:07 -0400
Tom Lane <tgl@sss.pgh.pa.us> wrote:


>
> You can set them in your ~/.psqlrc file.
>
>             regards, tom lane
>

It was easy, thanks :)

regards
S.