On Wed, Sep 02, 2009 at 10:52:07AM -0400, Himanshu Gupta wrote:
> Thanks for response, bit if I point it to all the schema, I am just
> wondering how data insertion will work, I have multiple ables with
> same name in these applications.
Do you know that you can schema qualify table names don't you? For
example, if you have a "users" table in schemas "app1" and "app2", you
can refer to the table in the first schema as:
SELECT uid, name
FROM app1.users;
--
Sam http://samason.me.uk/