Обсуждение: concept question: PostgreSQL vs. Oracle database

i'm a PostgreSQL newbie trying to set up a PostgreSQL for development
purposes. i've previously been using Oracle8i and i'm a bit confused about
the differences in database and user concepts in Oracle vs. PostgreSQL. in
Oracle all the users in a database have their own database schemas by
default. in PostgreSQL this doesn't seem to be the case. when i create a
database and connect to it with two different user accounts both see
tables created by the other. is database in PostgreSQL more like a
database schema in Oracle? where could i find a definition of these
concepts?

--
    aspa

On Mon, Aug 05, 2002 at 10:31:42AM +0300, Marko Asplund wrote:

> tables created by the other. is database in PostgreSQL more like a
> database schema in Oracle? where could i find a definition of these
> concepts?

Sort of.  It would be more accurate to say that Postgres doesn't have
schemas.  It will in 7.3.

A

--
----
Andrew Sullivan                               87 Mowat Avenue
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M6K 3E3
                                         +1 416 646 3304 x110