Hello fellow hackers,
Today when I get back home and connected to my psql prompt I've left
running under $terminal_multiplexor I've run some SQL, but no output did
appear on my screen. I have immediately realized that it must be
sending it to a file instead of STDOUT as I have instructed it earlier
today using \o command, but have totally forgot about the fact.
So I wonder if there's a way to make psql display the current output
file/command in the prompt? After reading the current docs, I don't see
any option. Would a patch be accepted for submission (make it into
default prompt, unless stdout?)
Something like this:
\set PROMPT1 '%/:%o%R%# '
postgres:/path/to/output/file.txt=>
--
Regards,
Alex
PS: upon reading the docs more carefully, I guess I should have used \g
instead of \o, but still this might be not a bad feature to have.