remaining_library_ids

#!/bin/bash

REMAINNG = $(sudo -u postgres -- psql -qtAX -d hshinfo -c "select (maximum_value::bigint - (SELECT last_value FROM hshinfo.seq_raw_library_id)) from information_schema.sequences where sequence_schema = 'hshinfo' and sequence_name = 'seq_raw_library_id';")

echo "P remaining_library_ids=$REMAINING;400:;200: That many library IDs are available."