#!/bin/sh

#         
# : updatetab c_.sql
#          
#    !
#   insert into...  !

if [ -z "$1" ] ; then
 echo Usage: $0 create_table.sql
 exit 1
fi

export PGUSER=keeper
file=$1
tab=`echo $file|perl -e 'while(<STDIN>) {$_=~s/c_(\w+)\.sql/$1/; print;}'`

if [ -z "$tab" ] ; then
 echo No table defined!
 exit
fi

echo -ne "alter table $tab rename to $tab""old;\n\\i $file\ndelete from $tab;\ninsert into $tab select * from $tab""old;\ndrop table $tab""old;\n"|psql packhouse
