A while back, I put together meta-slonik for just this purpose.

http://www.sitening.com/meta-slonik

--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC

Strategic Open Source: Open Your i?

http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005

On Jun 10, 2005, at 1:25 PM, Christopher Browne wrote:

> Tang, Jason wrote:
>
>
>> Hi All,
>>
>> I've been gifted with the task of implementing replication. I've  
>> had it
>> replicating a simple db. However now I'm going to be doing it for  
>> real
>> and the actual db has far too many tables/sequences to do it by hand.
>> I'm wondering if anyone out there has been through the exercise of
>> writing something to pull out and generate a file to describe the  
>> set as
>> a starting point.
>>
>> I thought I'd ask on here as it seems silly to potentially  
>> reinvent the
>> wheel again. Any related links you guys could direct me towards
>>
>>
>>
> There's a tool in the "altperl" directory that is called  
> "build_env.pl"
> or "slonik_build_env.pl" which tries to build a config file for the
> "altperl" tools as a starting point for you.
>
> Other than that, it wouldn't be too hard to build a query that  
> rummages
> around in the information_schema namespace for table and sequence  
> names
> and generates, as output, a set of "set add table" and "set add
> sequence" statements.