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