postgresql backup per table
for a in `psql nextg_dei3 -t -c "select table_name from information_schema.tables where table_type='BASE TABLE' and table_catalog='nextg_dei3' and table_schema='public'"`; do echo $a; pg_dump -t $a nextg_dei3 -f $a.sql 2> error/$a.txt; done

0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home