On Mon, Apr 17, 2006 at 09:42:59AM +0700, slackman@xxxxxxxxxxx wrote: > Now I have 3 database A,B,C is working in Interbase v 5.6, > but Interbas v 5.6 is no longger can hold what the client wants, > I will conver it in Postgresql, I need your advice which is the > bertter result: > > (1): > unika (schema) > | > |------ A > |------------ B > |------------------- C > > (2) create database A, create database B, create database C Which way is "better" depends on your access patterns. PostgreSQL doesn't support cross-database queries (except via functions like dblink), so if you need to join tables in one database with tables in another then you'll probably want make A, B, and C schemas in the same database. But if A, B, and C have no relationship with one another then you might want to isolate them as separate databases. -- Michael Fuhr
