bashからpsqlを非対話で使う

#!/bin/bash

DATABASE="testcopy"
DIRPATH="/hogehoge/postgres/files/"

### database作成
psql -c "create database ${DATABASE}"

### テーブル定義
psql ${DATABASE} < ${DIRPATH}/ddl/s.txt
psql ${DATABASE} < ${DIRPATH}/ddl/s2.txt
psql -c "\c ${DATABASE}" -c "\dt"

### データのロード
psql -c "\c ${DATABASE}" -c "\copy mytable  from ${DIRPATH}/csv/1.csv with csv header ;"
psql -c "\c ${DATABASE}" -c "\copy newtable from ${DIRPATH}/csv/4.csv with csv header ;"

### 確認
psql -c "\c ${DATABASE}" -c "select * from mytable ;"
psql -c "\c ${DATABASE}" -c "select * from newtable;"