root/bin/export_analytical_db @ 6681
| 1 | 6468 | aaronmk | #!/bin/bash
|
|---|---|---|---|
| 2 | # Exports analytical DB
|
||
| 3 | |||
| 4 | selfDir="$(dirname -- "$0")" |
||
| 5 | |||
| 6 | 6470 | aaronmk | out="$selfDir/../backups/analytical_aggregate.${public=public}.csv" |
| 7 | 6468 | aaronmk | |
| 8 | "$selfDir/psql_script_vegbien" >"$out" <<EOF |
||
| 9 | 6492 | aaronmk | COPY analytical_aggregate TO STDOUT CSV HEADER NULL 'NULL';
|
| 10 | 6468 | aaronmk | EOF
|