0.039
@ kaotonik.net → homes → thk → pg_trans
pg_trans
thk thk Tue. 16 Oct. 2018 16:21 1 comments download (579 hits)
I am doing again python postgresql migrating my booking app into hotelevropi.com

needed a script to transfer specific tables data

this script will copy data from postgres db1 table into db 2 table



#!/bin/bash
#will copy data from postgres db1 table into db 2 table
#usage is pg_trans.sh db1 db2 table


if [ $# -lt 3 ]
then
echo "Usage is: `basename $0` db1 db2 table"
exit 2
fi

db1=$1
db2=$2
table=$3

tmpfile=`mktemp`
chmod 666 $tmpfile
psql -c "copy $table to '$tmpfile'" -d $db1
psql -c "copy $table from '$tmpfile'" -d $db2
rm $tmpfile

comments
from cHARaKter cHARaKter 2018-10-19 15:03