Skip site navigation (1) Skip section navigation (2)

Re: A few comparison terms just to be sure.

From: "Dale Cooper" <sa_dale_cooper(at)hotmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: A few comparison terms just to be sure.
Date: 2007-07-01 22:19:30
Message-ID: BAY108-F37BDF7BC4B97CBB35667D6D50E0@phx.gbl (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

>From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
>To: "Dale Cooper" <sa_dale_cooper(at)hotmail(dot)com>
>CC: pgsql-novice(at)postgresql(dot)org
>Subject: Re: [NOVICE] A few comparison terms just to be sure. Date: Sun, 01 
>Jul 2007 17:54:38 -0400
>"Dale Cooper" <sa_dale_cooper(at)hotmail(dot)com> writes:
> > The questions:
> > 1- What I know as an oracle database (a group of schemas), in postgresql 
> > called a cluster. Is that right?
>No.  A group of schemas is a database, a group of databases is a cluster
>(a/k/a installation).  I think the SQL-spec term for what we call a
>database is a "catalog"; not sure if Oracle uses that terminology.
> > 2- what I know as "schema", in postgresql is called a "database"?
>No, it's called a schema.  (Or at least it is if Oracle uses the spec
> > 3- Every user is the superuser of his own schema/database but is there a
> > SYS/SYSMAN/SYSTEM (DBA) user who has access to all "databases"? I place
> > where I can log in and control what everyone is doing?
>In the first place, an ordinary user isn't "the superuser" of anything;
>he may own a table or a schema or a database but that doesn't give him
>superuser privileges, only the ability to drop or modify that object.
>The OS user that created the installation is a true superuser --- the
>documentation always refers to this user as "postgres" but you don't
>necessarily have to run Postgres under that username.
> > 4- What in Oracle is the SYSTEM/SYSAUX schema (where all oracle's own
> > objects reside) is the "postgres" database (I didn't find this schema
> > although I read about in the docs: chapter 16.2)?
>Perhaps you are looking for the pg_catalog schema.  See chapter 43
>(system catalogs).
>			regards, tom lane
Thanks Tom for your time and really quick answer (it seems I need to keep up 
reading :)).


MSN Amor: busca tu ½ naranja

In response to

pgsql-novice by date

Next:From: John SummerfieldDate: 2007-07-01 23:28:04
Subject: Re: yet another simple SQL question
Previous:From: Tom LaneDate: 2007-07-01 21:54:38
Subject: Re: A few comparison terms just to be sure.

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group