Portability fix for pg_dumpall.

bmomjian · bmomjian · commit 63fbdd358fa6 · 1997-08-20T15:06:48.000Z
diff --git a/src/bin/pg_dump/pg_dumpall b/src/bin/pg_dump/pg_dumpall
@@ -18,11 +18,11 @@ fi
 #
 # get the postgres user id
 #
-POSTGRES_SUPER_USER_ID="`psql -A -q -t template1 <<END
-select datdba
-from pg_database
-where datname = 'template1';
-END`"
+POSTGRES_SUPER_USER_ID="`echo \" \
+			select datdba \
+			from pg_database \
+			where datname = 'template1'; \" | \
+			psql -A -q -t template1`"
 echo "${BS}connect template1"
 #
 # delete all users in case they run this twice

Original file line number	Diff line number	Diff line change
`@@ -18,11 +18,11 @@ fi`
`18`	`18`	`#`
`19`	`19`	`# get the postgres user id`
`20`	`20`	`#`
`21`		-POSTGRES_SUPER_USER_ID="`psql -A -q -t template1 <<END
`22`		`-select datdba`
`23`		`-from pg_database`
`24`		`-where datname = 'template1';`
`25`		-END`"
	`21`	+POSTGRES_SUPER_USER_ID="`echo \" \
	`22`	`+ select datdba \`
	`23`	`+ from pg_database \`
	`24`	`+ where datname = 'template1'; \" \| \`
	`25`	+ psql -A -q -t template1`"
`26`	`26`	`echo "${BS}connect template1"`
`27`	`27`	`#`
`28`	`28`	`# delete all users in case they run this twice`