Re: multi-company design/structure ?

> 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!