| From: | Alex <ash(at)commandprompt(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Display output file name in psql prompt? |
| Date: | 2013-03-12 20:05:10 |
| Message-ID: | 87zjy8bczt.fsf@commandprompt.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2013-03-12 21:41:59 | Re: Display output file name in psql prompt? |
| Previous Message | Josh Berkus | 2013-03-12 20:02:10 | Re: Incorrect handling of timezones with extract |