On Wed, Dec 13, 2000 at 06:26:08PM +1100, Aarmel wrote:
> [...]
> database1 -> table1, table2, table3
>
> database2 -> table1, table2, table3
>
> database3 -> table1, table2, table3.
>
> OR
>
> database -> database1table1, database1table2, database3table1 etc.
> [...]
> Also we need to be able to search all the tables acrosss all the databases.
Since Postgres doesn't currently support queries over multiple
databases, the best choice would probably be putting all the tables
in a single database. And I'd be inclined to choose that design just
for simplicities sake anyway.
HTH,
Neil
--
Neil Conway <neilconway@home.com>
Get my GnuPG key from: http://klamath.dyndns.org/mykey.asc
Encrypted mail welcomed
People of privilege will always risk their complete destruction
rather than surrender any material part of their advantage.
-- John Kenneth Galbraith