What's the point of multiple databases?

From: Martin Maney <maney(at)pobox(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: What's the point of multiple databases?
Date: 2000-06-27 05:11:32
Message-ID: 20000627001132.A25627@furrr.two14.lan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I hope I don't regret too much not waiting for morning and a fresh take on
all this. :-)

So I've got this nice new postgreSQL and it seems to be working nicely.
I've setup a user identity with create database priviliges, and set out to
setup a couple databases for separate projects I want to work on. That's
what separately named databases are for, right?

Well, maybe it's just a quirk of the utilities (psql and pgaccess), but it
seems that no matter which database I open, I can see and access all the
tables in any database created by this user. This seems, well, wrong.

This is from the Debian "potato" install, which is based on 6.5.3. All I
need is a sanity check, please: is this doable, or is there no point in
setting up more than one database per postgres user?

Thanks!

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Poul L. Christiansen 2000-06-27 10:56:23 Re: Get all names of tables in a database
Previous Message nronayette 2000-06-26 20:16:33 Re: Phantom record problem.