[sr-dev] git:5.1:54c904e4: utils/kamctl: [pgsql] add missing options for pgsql_ro_query()

[Victor Seva]

Module: kamailio
Branch: 5.1
Commit: 54c904e4dc9dae3cd82e547e2328cad9381e48ec
URL: https://github.com/kamailio/kamailio/commit/54c904e4dc9dae3cd82e547e2328cad9381e48ec

Author: Victor Seva <linuxmaniac at torreviejawireless.org>
Committer: Victor Seva <linuxmaniac at torreviejawireless.org>
Date: 2018-12-03T12:31:18+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/54c904e4dc9dae3cd82e547e2328cad9381e48ec.diff
Patch: https://github.com/kamailio/kamailio/commit/54c904e4dc9dae3cd82e547e2328cad9381e48ec.patch

---

diff --git a/utils/kamctl/kamctl.pgsql b/utils/kamctl/kamctl.pgsql
index 7e5abaef9a..1250dc0d7e 100644
--- a/utils/kamctl/kamctl.pgsql
+++ b/utils/kamctl/kamctl.pgsql
@@ -57,15 +57,17 @@ 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'"
 	if [ -z "$DBPORT" ] ; then
 		PGPASSWORD="$DBROPW" $PGSQL $2 \
+			-A -q -t \
 			-h $DBHOST \
 			-U $DBROUSER \
 			$DBNAME \
 			-c "$1"
 	else
 		PGPASSWORD="$DBROPW" $PGSQL $2 \
+			-A -q -t \
 			-h $DBHOST \
 			-p $DBPORT \
 			-U $DBROUSER \