Advertisement
cmptrwz

QP Fix bash script

Feb 15th, 2013
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.65 KB | None | 0 0
  1. #!/bin/bash
  2. export PGHOST=SOMEHOST
  3. export PGUSER=SOMEUSER
  4. export PGPASSWORD=SOMEPASS
  5. export PGDATABASE=SOMEDB
  6.  
  7. date
  8.  
  9. psql -c "UPDATE metabib.identifier_field_entry set value = value;" &
  10. psql -c "UPDATE metabib.title_field_entry set value = value;" &
  11. psql -c "UPDATE metabib.author_field_entry set value = value;" &
  12. psql -c "UPDATE metabib.subject_field_entry set value = value;" &
  13. psql -c "UPDATE metabib.keyword_field_entry set value = value;" &
  14. psql -c "UPDATE metabib.series_field_entry set value = value;" &
  15.  
  16. wait
  17.  
  18. date
  19.  
  20. psql -c "SELECT count(metabib.update_combined_index_vectors(id)) FROM biblio.record_entry WHERE NOT deleted;"
  21.  
  22. date
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement