Under Microsoft SQL, a fully qualified table name is db.owner.tablename (well actually, linked_server.db.owner.table, but we won't go there :) Under Postgres, you can create schemas to simulate different databases within the one actual database, but as far as I can tell, the owner does not contribute to the namespace at all. I can't have two views with the same name in the same database but with different owners (eg mydb.james.myview and mydb.fred.myview). Can someone tell me if this is correct? Assuming I'm correct, how well might it work if I created schema's in the form db_owner, eg mydb_james and mydb_fred, to emulate this? There would also be the schema of the dbo which mydb_dbo, which is also searched given an unqualified table name. If I'm logged in as james, my search path would be mydb_james then mydb_dbo. ? Thanks James
