Fernando Schapachnik wrote:
> 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 ??
> 
> 
Thanks it should help but as Chritopher says I must think in migrating
to 8.0 or look for another tool.
Thanks to all for your answers.