Commit275f05c

committed

Add psql PROMPT variable showing the pid of the connected to backend.

The substitution for the pid is %p.Author: Julien RouhaudDiscussion: 116262CF971C844FB6E793F8809B51C6E99D48@BPXM02GP.gisp.nec.co.jp

1 parentb2f6f74 commit275f05cCopy full SHA for 275f05c

File tree

+17

-0

lines changed

+17

-0

lines changed

Lines changed: 7 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -3364,6 +3364,13 @@ testdb=> <userinput>INSERT INTO my_table VALUES (:'content');</userinput>`
`3364`	`3364`	`</listitem>`
`3365`	`3365`	`</varlistentry>`
`3366`	`3366`
	`3367`	`+ <varlistentry>`
	`3368`	`+ <term><literal>%p</literal></term>`
	`3369`	`+ <listitem>`
	`3370`	`+ <para>The pid of the backend currently connected to.</para>`
	`3371`	`+ </listitem>`
	`3372`	`+ </varlistentry>`
	`3373`	`+`
`3367`	`3374`	`<varlistentry>`
`3368`	`3375`	`<term><literal>%></literal></term>`
`3369`	`3376`	`<listitem><para>The port number at which the database server is listening.</para></listitem>`

Lines changed: 10 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -34,6 +34,7 @@`
`34`	`34`	`* %M - database server "hostname.domainname", "[local]" for AF_UNIX`
`35`	`35`	`*sockets, "[local:/dir/name]" if not default`
`36`	`36`	`* %m - like %M, but hostname only (before first dot), or always "[local]"`
	`37`	`+ * %p - backend pid`
`37`	`38`	`* %> - database server port number`
`38`	`39`	`* %n - database user name`
`39`	`40`	`* %/ - current database`
`@@ -161,6 +162,15 @@ get_prompt(promptStatus_t status)`
`161`	`162`	`if (pset.db)`
`162`	`163`	`strlcpy(buf,session_username(),sizeof(buf));`
`163`	`164`	`break;`
	`165`	`+/* backend pid */`
	`166`	`+case'p':`
	`167`	`+if (pset.db)`
	`168`	`+{`
	`169`	`+intpid=PQbackendPID(pset.db);`
	`170`	`+if (pid)`
	`171`	`+snprintf(buf,sizeof(buf),"%d",pid);`
	`172`	`+}`
	`173`	`+break;`
`164`	`174`
`165`	`175`	`case'0':`
`166`	`176`	`case'1':`

Comments

(0)