Fernando Schapachnik fernando
Wed Apr 20 17:44:41 PDT 2005
Consider the scripting way:

cmd="SELECT schemaname || '.' || tablename from pg_tables';"
list=`$psql -c "$cmd" `

i=1
for k in $list
do
        echo "set add table (set id=1, origin=1, id=$i, fully qualified name = 
'$k');" >> $arch
        i=`expr $i + 1`
done

Or something alike.

En un mensaje anterior, Twilight escribi?:
> Hi to everyone, I'm trying to replicate all the databases my postgres
> has (near 60). Obviously I cant specify for each database its tables
> when creating a set. There's anyway to do what I want or slony-1 is not
> what I need ??


More information about the Slony1-general mailing list