[sr-dev] git:4.4:97f3081f: utils/kamctl: [pgsql] add missing options for pgsql_ro_query()

[Victor Seva]

Module: kamailio
Branch: 4.4
Commit: 97f3081f8af788e0c4a420e22bd2d5267f43d4ec
URL: https://github.com/kamailio/kamailio/commit/97f3081f8af788e0c4a420e22bd2d5267f43d4ec

Author: Victor Seva <linuxmaniac at torreviejawireless.org>
Committer: Victor Seva <linuxmaniac at torreviejawireless.org>
Date: 2018-12-03T12:34:21+01:00

utils/kamctl: [pgsql] add missing options for pgsql_ro_query()

Thanks Andreas Maus <maus+debianbug at ypbind.de>

fix #1750

(cherry picked from commit 1894b378f975e7129024f6f10640c6c642e30a1b)

---

Modified: utils/kamctl/kamctl.pgsql

---

Diff:  https://github.com/kamailio/kamailio/commit/97f3081f8af788e0c4a420e22bd2d5267f43d4ec.diff
Patch: https://github.com/kamailio/kamailio/commit/97f3081f8af788e0c4a420e22bd2d5267f43d4ec.patch

---

diff --git a/utils/kamctl/kamctl.pgsql b/utils/kamctl/kamctl.pgsql
index 60cbd92f06..8b9e7f04bf 100644
--- a/utils/kamctl/kamctl.pgsql
+++ b/utils/kamctl/kamctl.pgsql
@@ -46,8 +46,9 @@ pgsql_query() {
 
 # input: sql query, optional pgsql command-line params
 pgsql_ro_query() {
-	mdbg "pgsql_ro_query: $PGSQL $2 -h $DBHOST -U $DBROUSER $DBNAME -c '$1'"
+	mdbg "pgsql_ro_query: $PGSQL $2 -A -q -t -h $DBHOST -U $DBROUSER $DBNAME -c '$1'"
 	PGPASSWORD="$DBROPW" $PGSQL $2 \
+		-A -q -t \
 		-h $DBHOST \
 		-U $DBROUSER \
 		$DBNAME \