Josh Harrison wrote:
>>
>>> On Wed, Dec 12, 2007 at 02:22:58PM -0500, Geoffrey wrote:
>>>> I was afraid that would be the answer, thanks.
>>> This is an easy script to write, though.  You can get every table name
>> out
>>> of postgres quite easily.
> 
> How do you write this script? I have a database with 100 tables and i have
> to replicate them all. And if tey dont have a PK then you have to generate a
> slony serial key...right!!!!
> josh


All of my tables have PK, so that's not a problem for me.  All I had to 
do was produce a common separated list of the tables and then import 
that into the slon_tools.conf file:

echo '\d' |psql -t -p 5443 swr|
	awk -F'|' '/ table /{gsub(" ", "", $2);printf "%s,\n", $2}'

-- 
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
  - Benjamin Franklin