#!/usr/local/bin/pgbash
source "system.conf"
#####################################################################
# "copy_data"
#
#  insert into member and password.
#####################################################################
#
#----------- connect to DATABASE ------------
connect to $PGDATABASE user $PGUSER $PGPASSWORD;
#set client_encoding='EUC_JP';

#---------- COPY member table from "member" ----------
delete from member;
copy member() from member.dat;

#---------- COPY member_passwd from "password" ----------
delete from member_passwd;
copy member_passwd() from password.dat;

disconnect all;
