aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2000-03-22 05:10:22 +0000
committerBruce Momjian <bruce@momjian.us>2000-03-22 05:10:22 +0000
commit233a52eaff5b5e48512dba5ee7e681034473b621 (patch)
treeae05ae31a007f2799d6b5860da4dd0d7267f44d5 /src
parente1a1f22f13fa6124466b68984915b2b8d865170d (diff)
downloadpostgresql-233a52eaff5b5e48512dba5ee7e681034473b621.tar.gz
postgresql-233a52eaff5b5e48512dba5ee7e681034473b621.zip
Fix pg_dumpall for new psql output.
Diffstat (limited to 'src')
-rw-r--r--src/bin/pg_dump/pg_dumpall4
1 files changed, 2 insertions, 2 deletions
diff --git a/src/bin/pg_dump/pg_dumpall b/src/bin/pg_dump/pg_dumpall
index 586e75d530c..377b296e850 100644
--- a/src/bin/pg_dump/pg_dumpall
+++ b/src/bin/pg_dump/pg_dumpall
@@ -47,7 +47,7 @@ copy tmp_pg_shadow to stdout;
drop table tmp_pg_shadow;
END
echo "${BS}."
-psql -l -A -q -t | grep '|' | tr '|' ' ' | \
+psql -A -q -t -c "select * from pg_database" template1 | grep '|' | tr '|' ' ' | \
grep -v '^template1 ' | \
while read DATABASE DBUSERID ENCODING DATAPATH
do
@@ -55,7 +55,7 @@ do
if pg_encoding $ENCODING >/dev/null 2>&1
then
- echo "create database $DATABASE with encoding='$ENCODING';"
+ echo "create database $DATABASE with encoding='`pg_encoding $ENCODING`';"
else
echo "create database $DATABASE;"
fi