Re: Any utility to auto-transfer table from one DB to another DB

You could change your unload script to SELECT " ", * from table to create an extra field, or you could run your unload file(s) through a sed or awk script to do the same. --- JouhShenToh@pg.SLR.com > wrote: >Hi, > >I have a set of scripts to do drop-create-load-index a collection of tables >from one database to another database. However, all target table schema has >an extra field, sysflag char(1), as the first field. > >Is there any utility can automate this process? Any help would be greatly >appreciated. Thanks. > >Regards, >Jouhshen == Maintainer of the procrastinator's FAQ. Well, maybe tomorrow I will be. _____________________________________________________________ Want a new web-based email account ? ---> http://www.firstlinux.net