RES: concept question: PostgreSQL vs. Oracle database

From: Elielson Fontanezi <ElielsonF(at)prodam(dot)sp(dot)gov(dot)br>
To: "'marko(dot)asplund(at)kronodoc(dot)fi'" <marko(dot)asplund(at)kronodoc(dot)fi>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: RES: concept question: PostgreSQL vs. Oracle database
Date: 2002-08-05 10:58:35
Message-ID: A799F7647794D311924A005004ACEA97080DDF0C@cprodamibs249.prodam
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear newbie!

Although Postgres is best free open ORDBMS available, it hasn´t
schemas as Oracle does. Schemas will come in next version os Postgres: 7.3.
All information you can find at www.postgres.org.

E.F.:> -----Mensagem original-----
E.F.:> De: marko(dot)asplund(at)kronodoc(dot)fi [mailto:marko(dot)asplund(at)kronodoc(dot)fi]
E.F.:> Enviada em: segunda-feira, 5 de agosto de 2002 06:58
E.F.:> Para: pgsql-general(at)postgresql(dot)org
E.F.:> Assunto: [GENERAL] concept question: PostgreSQL vs.
E.F.:> Oracle database
E.F.:>
E.F.:>
E.F.:>
E.F.:> i'm a PostgreSQL newbie trying to set up a PostgreSQL
E.F.:> for development
E.F.:> purposes. i've previously been using Oracle8i and i'm a
E.F.:> bit confused about
E.F.:> the differences in database and user concepts in Oracle
E.F.:> vs. PostgreSQL. in
E.F.:> Oracle all the users in a database have their own
E.F.:> database schemas by
E.F.:> default. in PostgreSQL this doesn't seem to be the case.
E.F.:> when i create a
E.F.:> database and connect to it with two different user
E.F.:> accounts both see
E.F.:> tables created by the other. is database in PostgreSQL
E.F.:> more like a
E.F.:> database schema in Oracle? where could i find a
E.F.:> definition of these
E.F.:> concepts?
E.F.:>
E.F.:> --
E.F.:> aspa
E.F.:>
E.F.:>
E.F.:> ---------------------------(end of
E.F.:> broadcast)---------------------------
E.F.:> TIP 3: if posting/reading through Usenet, please send an
E.F.:> appropriate
E.F.:> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
E.F.:> message can get through to the mailing list cleanly
E.F.:>

Browse pgsql-general by date

  From Date Subject
Next Message Karel Zak 2002-08-05 11:17:37 Re: Convert number of month to name of month
Previous Message Richard Huxton 2002-08-05 10:48:02 Puzzling planner choice (non-urgent)