Re: how to use multiple schema's - Mailing list pgsql-general

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/