Re: how to use multiple schema's

Sam Mason wrote:
> 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;

Himanshu didn't mention if he has access to the code for the
applications or can edit them.


\\||/
Rod
--