Restores a single table from a dump file to the configured database.

restore-table.sh

#!/bin/bash

table=$1

if [ -z "$table" ];
then
    echo "Usage: $0 [table-name]"
    exit
fi

jdbcPort=
jdbcDatabase=
jdbcHost=
jdbcUser=
jdbcPassword=

pg_restore --dbname=${jdbcDatabase} \
           --host=${jdbcHost} \
           --username=${jdbcUser} \
           --password \
           --port=${jdbcPort} \
           --single-transaction \
           --no-owner \
           --verbose \
           -L \
           dump.list dump.dmp.orig