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
--
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
