You signed in with another tab or window.Reload to refresh your session.You signed out in another tab or window.Reload to refresh your session.You switched accounts on another tab or window.Reload to refresh your session.Dismiss alert
@@ -29,8 +29,8 @@ if echo "$0" | grep '/' > /dev/null 2>&1 ; then
29
29
PGPATH=`echo"$0"| sed's,/[^/]*$,,'`# (dirname command is not portable)
30
30
else
31
31
# look for it in PATH ('which' command is not portable)
32
-
echo"$PATH"| sed's/:/\
33
-
/g'|while:;do
32
+
echo"$PATH"| sed"s/:/$NL/g"|
33
+
while:;do
34
34
IFS="$NL"
35
35
read dir||break
36
36
IFS="$_IFS"
@@ -203,8 +203,8 @@ echo "DELETE FROM pg_group;"
203
203
echo
204
204
205
205
206
-
$PSQL -d template1 -At -F'
207
-
' -c'SELECT groname,grosysid,grolist FROM pg_group;'| \
206
+
$PSQL -d template1 -At -F"$NL" \
207
+
-c'SELECT groname,grosysid,grolist FROM pg_group;'| \
208
208
while:;do
209
209
IFS="$NL"
210
210
read GRONAME||break
@@ -232,8 +232,8 @@ exec 4<&0
232
232
# We skip databases marked not datallowconn, since we'd be unable to
233
233
# connect to them anyway (and besides, we don't want to dump template0).
234
234
235
-
$PSQL -d template1 -At -F'
236
-
' -c"SELECT datname, coalesce(usename, (select usename from pg_shadow where usesysid=(select datdba from pg_database where datname='template0'))), pg_encoding_to_char(d.encoding), datistemplate, datpath FROM pg_database d LEFT JOIN pg_shadow u ON (datdba = usesysid) WHERE datallowconn ORDER BY 1;"| \
235
+
$PSQL -d template1 -At -F"$NL" \
236
+
-c"SELECT datname, coalesce(usename, (select usename from pg_shadow where usesysid=(select datdba from pg_database where datname='template0'))), pg_encoding_to_char(d.encoding), datistemplate, datpath FROM pg_database d LEFT JOIN pg_shadow u ON (datdba = usesysid) WHERE datallowconn ORDER BY 1;"| \
237
237
whileread DATABASE;do
238
238
IFS="$NL"
239
239
read DBOWNER
@@ -262,8 +262,8 @@ while read DATABASE ; do
262
262
fi
263
263
done
264
264
265
-
$PSQL -d template1 -At -F'
266
-
' -c"SELECT datname FROM pg_database WHERE datallowconn ORDER BY 1;"| \
265
+
$PSQL -d template1 -At -F"$NL" \
266
+
-c"SELECT datname FROM pg_database WHERE datallowconn ORDER BY 1;"| \