install-eg.sh: fix setup of non-prod Apache includes
[sitka/sitka-tools.git] / marc_export_custom / fetch-shortcodes.sh
CommitLineData
9c8cd3ac 1#!/bin/bash
2eafa422 2psql -Upostgres -U evergreen evergreen -h db1.sitka.bclibraries.ca -o shortcodes.csv \
9c8cd3ac
RJ
3-c "COPY (
4 SELECT
5 a.shortname,a.name,b.shortname AS parent
6 FROM actor.org_unit a
7 JOIN actor.org_unit b
8 ON (a.parent_ou = b.id)
9 ORDER BY shortname
10 ) TO STDOUT WITH CSV HEADER QUOTE AS '\"' FORCE QUOTE shortname, name, parent;"
11