schema or database

From: Michael Cheung <vividy(at)justware(dot)co(dot)jp>
To: pgsql-general(at)postgresql(dot)org
Subject: schema or database
Date: 2015-04-13 02:08:08
Message-ID: 20150413110808.6157.8B406A0E@justware.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi, all;

I am new here. And I need some suggestion.

I have many similar database to store data for every customer.
Structure of database is almost the same.
As I use same application to control all these data, so I can only use
one database user to connect to these database.
And I have no needs to query table for different customer together.

I wonder which I should use, different shema or different database to store data?

I 'd like to know the advantage and disadvantage for using schema or database.

Thanks

michael

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ian Barwick 2015-04-13 02:20:59 Re: schema or database
Previous Message Jim Nasby 2015-04-13 00:40:12 Re: Help with slow table update