BUG #1539: Suggestion

Started by Patrick Boulayabout 21 years ago2 messagesbugs
Jump to latest
#1Patrick Boulay
pboulay@medrium.com

The following bug has been logged online:

Bug reference: 1539
Logged by: Patrick Boulay
Email address: pboulay@medrium.com
PostgreSQL version: 7.4.5
Operating system: Unix Solaris
Description: Suggestion
Details:

Sometime I do transaction and I do a couple of commands on SQL shell and I
forgot to commit my commands before testing my software.

Is it possible to change a prompt character during a transaction?
instead of:
database=#

it can be
database=>

or something like that!! After the commit, the prompt come back to
database=#

example:
database=# begin;
database=> insert into somewhere values(1);
...
database=> end;
database=#

it's more clear! :)

Patrick

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Patrick Boulay (#1)
Re: BUG #1539: Suggestion

"Patrick Boulay" <pboulay@medrium.com> writes:

Is it possible to change a prompt character during a transaction?

Yes, read the psql reference page's section about "Prompting".

regards, tom lane