ADB数据库自动导出数据脚本
export.sh
table_name=$1
###需要导数的sql
select_sql=`cat /**/**sc_read/tmp/**/test/${table_name}.sql`
##ADB数据库导出语法
sql="
\pset fieldsep ','
\pset format unaligned
\o /**/**sc_read/tmp/**/test/result/${table_name}.csv
$select_sql
"
echo "$sql"
echo "$sql" > sql.conf
txt_file=sql.conf
sh /**/**sc_read/tmp/**/test/run.sh ${txt_file} 20230801
run.sh
psql="/**/etl/bin/psql.sh"
env="/**/etl/etc/LOGON_ETL_**.env"
test=$1
TX_DATE=$2
sh /**/etl/bin/psql.sh /**/etl/etc/LOGON_ETL_**.env /**/**sc_read/tmp/**/test/${test} TX_DATE=${TX_DATE} ## 1>>./log/$1_`date "+%H%M%S"`.log 2>&1