+PATH="@POSTGRESQL_BINDIR@:$PATH"
+db_name=${db_name:-@db_name@}
+
+#
+# use SQL_ASCII to be able to put any filename into
+# the database even those created with unusual character sets
+
+PSQLVERSION=`psql -d template1 -c 'select version()' $* | awk '/PostgreSQL/ {print $2}' | cut -d '.' -f 1,2`
+
+#
+# Note, LC_COLLATE and LC_TYPE are needed on 8.4 and beyond, but are
+# not implemented in 8.3 or below.
+# This must be updated for future versions of PostgreSQL
+#
+case ${PSQLVERSION} in
+ 8.[456789] | 9.* | 10.*)
+ ENCODING="ENCODING 'SQL_ASCII' LC_COLLATE 'C' LC_CTYPE 'C'"
+ ;;
+ *)
+ ENCODING="ENCODING 'SQL_ASCII'"
+ ;;
+esac
+
+