|
6 | 6 | # and "pg_group" tables, which belong to the whole installation rather |
7 | 7 | # than any one individual database. |
8 | 8 | # |
9 | | -# $Header: /cvsroot/pgsql/src/bin/pg_dump/Attic/pg_dumpall.sh,v 1.9 2000/12/19 22:12:47 petere Exp $ |
| 9 | +# $Header: /cvsroot/pgsql/src/bin/pg_dump/Attic/pg_dumpall.sh,v 1.10 2001/01/25 17:28:15 petere Exp $ |
10 | 10 |
|
11 | 11 | CMDNAME=`basename$0` |
12 | 12 |
|
@@ -192,7 +192,7 @@ test "$globals_only" = yes && exit 0 |
192 | 192 | # connect to them anyway (and besides, we don't want to dump template0). |
193 | 193 |
|
194 | 194 | $PSQL -d template1 -At -F'' \ |
195 | | - -c"SELECT datname, usename, pg_encoding_to_char(d.encoding), datistemplate, datpath FROM pg_database d LEFT JOIN pg_shadow u ON (datdba = usesysid) WHERE datallowconn;"| \ |
| 195 | + -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;"| \ |
196 | 196 | whileread DATABASE DBOWNER ENCODING ISTEMPLATE DBPATH;do |
197 | 197 | echo |
198 | 198 | echo"--" |
|