[sitka/sitka-tools.git] / marc_export_custom / fetch-shortcodes.sh

#!/bin/bash 
psql -Upostgres -U evergreen evergreen -h db1.sitka.bclibraries.ca -o shortcodes.csv \
-c "COPY (
      SELECT
        a.shortname,a.name,b.shortname AS parent
      FROM actor.org_unit a
      JOIN actor.org_unit b
        ON (a.parent_ou = b.id)
      ORDER BY shortname
    ) TO STDOUT WITH CSV HEADER QUOTE AS '\"' FORCE QUOTE shortname, name, parent;"
Commit	Line	Data
9c8cd3ac	1	#!/bin/bash
2eafa422	2	psql -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