pg.ddx.io pgsql-hackers@postgresql.org mailing list archive
help / color / mirror / Atom feedFrom: Vik Fearing <vik.fearing@2ndquadrant.com>
To: PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Add %x to PROMPT1 and PROMPT2
Date: Sun, 26 Jan 2020 13:29:16 +0100
Message-ID: <09502c40-cfe1-bb29-10f9-4b3fa7b2bbb2@2ndquadrant.com> (raw)
I cannot ever think of a time when I don't want to know if I'm in a
transaction or not (and what its state is). Every new setup I do, I add
%x to the psql prompt.
I think it should be part of the default prompt. Path attached.
--
Vik Fearing
Attachments:
[text/x-patch] 0001-add-x-to-the-default-psql-prompt.patch (1.3K, ../09502c40-cfe1-bb29-10f9-4b3fa7b2bbb2@2ndquadrant.com/2-0001-add-x-to-the-default-psql-prompt.patch)
download | inline diff:
From 6118b8b2ab4cfc70525666b8d57eaa351d6c2a3d Mon Sep 17 00:00:00 2001
From: Vik Fearing <vik.fearing@2ndquadrant.com>
Date: Fri, 23 Nov 2018 22:26:18 +0100
Subject: [PATCH] add %x to the default psql prompt
---
doc/src/sgml/ref/psql-ref.sgml | 2 +-
src/bin/psql/settings.h | 4 ++--
2 files changed, 3 insertions(+), 3 deletions(-)
diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml
index 48b081fd58..20ba105160 100644
--- a/doc/src/sgml/ref/psql-ref.sgml
+++ b/doc/src/sgml/ref/psql-ref.sgml
@@ -4332,7 +4332,7 @@ testdb=> \set PROMPT1 '%[%033[1;33;40m%]%n@%/%R%[%033[0m%]%# '
To insert a percent sign into your prompt, write
<literal>%%</literal>. The default prompts are
- <literal>'%/%R%# '</literal> for prompts 1 and 2, and
+ <literal>'%/%R%x%# '</literal> for prompts 1 and 2, and
<literal>'>> '</literal> for prompt 3.
</para>
diff --git a/src/bin/psql/settings.h b/src/bin/psql/settings.h
index d2a9d4836a..2b384a38a1 100644
--- a/src/bin/psql/settings.h
+++ b/src/bin/psql/settings.h
@@ -23,8 +23,8 @@
#define DEFAULT_EDITOR_LINENUMBER_ARG "+"
#endif
-#define DEFAULT_PROMPT1 "%/%R%# "
-#define DEFAULT_PROMPT2 "%/%R%# "
+#define DEFAULT_PROMPT1 "%/%R%x%# "
+#define DEFAULT_PROMPT2 "%/%R%x%# "
#define DEFAULT_PROMPT3 ">> "
/*
--
2.17.1
view thread (23+ messages) latest in thread
Message-ID: <09502c40-cfe1-bb29-10f9-4b3fa7b2bbb2@2ndquadrant.com>
Permalink: ../09502c40-cfe1-bb29-10f9-4b3fa7b2bbb2@2ndquadrant.com/
Also on: postgresql.org/message-id/09502c40-cfe1-bb29-10f9-4b3fa7b2bbb2@2ndquadrant.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: vik.fearing@2ndquadrant.com
Subject: Re: Add %x to PROMPT1 and PROMPT2
In-Reply-To: <09502c40-cfe1-bb29-10f9-4b3fa7b2bbb2@2ndquadrant.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox