Modify Outlook export profile for Radium, per RT#74886
[sitka/sitka-tools.git] / marc_export_custom / fetch-shortcodes.sh
CommitLineData
9c8cd3ac 1#!/bin/bash
ec4760e5
JD
2SHORTCODES=$1
3if [ -z "${SHORTCODES}" ]; then
4 SHORTCODES="shortcodes.csv"
5fi
9d5bf491 6psql -Upostgres -U evergreen evergreen -h dbprod-96-main-ndb2 -o $SHORTCODES \
9c8cd3ac
RJ
7-c "COPY (
8 SELECT
9 a.shortname,a.name,b.shortname AS parent
10 FROM actor.org_unit a
11 JOIN actor.org_unit b
12 ON (a.parent_ou = b.id)
13 ORDER BY shortname
14 ) TO STDOUT WITH CSV HEADER QUOTE AS '\"' FORCE QUOTE shortname, name, parent;"
15