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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

"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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings