diff options
-rwxr-xr-x | makecolumns.sh | 12 | ||||
-rw-r--r-- | src/postprocess/postgres.txt | 2 |
2 files changed, 7 insertions, 7 deletions
diff --git a/makecolumns.sh b/makecolumns.sh index e10165d..4381f13 100755 --- a/makecolumns.sh +++ b/makecolumns.sh | |||
@@ -68,19 +68,19 @@ do_decompress_version_3() { | |||
68 | 68 | ||
69 | do_processfile_version_3() { | 69 | do_processfile_version_3() { |
70 | working_on=`basename ${1}` | 70 | working_on=`basename ${1}` |
71 | mkdir $working_on && cd ${working_on} | 71 | mkdir "${working_on}" && cd "${working_on}" |
72 | do_decompress_version_3 "${1}" "${2}" | 72 | do_decompress_version_3 "${1}" "${2}" |
73 | cd .. | 73 | cd .. |
74 | 74 | ||
75 | printf "Combining $2 into single file ... " | 75 | printf "Combining $2 into single file ... " |
76 | if [ "${4}" = "convert_zeros" ]; then | 76 | if [ "${4}" = "convert_zeros" ]; then |
77 | cat ${working_on}/* | tr '\n\0' '\t\n' > $3 | 77 | cat "${working_on}"/* | tr '\n\0' '\t\n' > $3 |
78 | else | 78 | else |
79 | cat ${working_on}/* > $3 | 79 | cat "${working_on}"/* > $3 |
80 | fi | 80 | fi |
81 | printf "done.\n" | 81 | printf "done.\n" |
82 | 82 | ||
83 | rm -rf ${working_on} | 83 | rm -rf "${working_on}" |
84 | } | 84 | } |
85 | 85 | ||
86 | size() { | 86 | size() { |
@@ -134,10 +134,10 @@ handle_format_version_2() { | |||
134 | for database in `find "$1" -iname atb?dd00`; do | 134 | for database in `find "$1" -iname atb?dd00`; do |
135 | dir=`dirname ${database}` | 135 | dir=`dirname ${database}` |
136 | base=`basename ${database}` | 136 | base=`basename ${database}` |
137 | printf " %d/3 in %4s. Decompressing ... " ${cd} "$( basename ${dir} )" | 137 | printf " %d/3 in %4s. Decompressing ..." ${cd} "$( basename ${dir} )" |
138 | extract_version_2 "${database}" > ${base}.dump | 138 | extract_version_2 "${database}" > ${base}.dump |
139 | 139 | ||
140 | printf ", extracting ... " | 140 | printf ", extracting ..." |
141 | indexfile=$( find ${dir} -iname atb?di00 ) | 141 | indexfile=$( find ${dir} -iname atb?di00 ) |
142 | split_version_2 "${base}.dump" "${indexfile}" | 142 | split_version_2 "${base}.dump" "${indexfile}" |
143 | 143 | ||
diff --git a/src/postprocess/postgres.txt b/src/postprocess/postgres.txt index 943a88a..e47ca00 100644 --- a/src/postprocess/postgres.txt +++ b/src/postprocess/postgres.txt | |||
@@ -62,7 +62,7 @@ CREATE INDEX trgm_idx_web ON indexed_view_web USING gin (value gi | |||
62 | CREATE INDEX trgm_idx_email ON indexed_view_email USING gin (value gin_trgm_ops); | 62 | CREATE INDEX trgm_idx_email ON indexed_view_email USING gin (value gin_trgm_ops); |
63 | 63 | ||
64 | # slow way: | 64 | # slow way: |
65 | SELECT * FROM Telefonbuch WHERE nachname = 'Engling'; | 65 | SELECT * FROM Telefonbuch WHERE nachname = 'CCC'; |
66 | 66 | ||
67 | # using the index: | 67 | # using the index: |
68 | SELECT * FROM Telefonbuch | 68 | SELECT * FROM Telefonbuch |