> Is it better to create multi databases or create multi schemas? You're missing one option imho: One database, one schema. > I am writing a program that can have multi instances. Sort like a finanical > accounting system that can have multiable companies. Where each company has a > different name but the tables are an exact match to each other. Then you could simply add a "company-id" column to every table (and make this column part of the primary key of each table). And if you run multiple instances of the program within _one_ company, then you can also add an "instance-id" column (and make this column also part of the primary key of each table). Sincerely, Wolfgang -- NO "Courtesy Copies" PLEASE! -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
