SITKA Public Git
/
sitka
/
sitka-tools.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
grabbing some uncommitted changes to BVIC Outlook exports from util server
[sitka/sitka-tools.git]
/
marc_export_custom
/
fetch-shortcodes.sh
diff --git
a/marc_export_custom/fetch-shortcodes.sh
b/marc_export_custom/fetch-shortcodes.sh
index
4c91014
..
a32c047
100755
(executable)
--- a/
marc_export_custom/fetch-shortcodes.sh
+++ b/
marc_export_custom/fetch-shortcodes.sh
@@
-3,7
+3,7
@@
SHORTCODES=$1
if [ -z "${SHORTCODES}" ]; then
SHORTCODES="shortcodes.csv"
fi
if [ -z "${SHORTCODES}" ]; then
SHORTCODES="shortcodes.csv"
fi
-psql -Upostgres -U evergreen evergreen -h
dbprod-96-main-ndb2
-o $SHORTCODES \
+psql -Upostgres -U evergreen evergreen -h
prod-pg96-db2-sitka
-o $SHORTCODES \
-c "COPY (
SELECT
a.shortname,a.name,b.shortname AS parent
-c "COPY (
SELECT
a.shortname,a.name,b.shortname AS parent