|
|
| Applications |
| Mailing Lists |
| Miscellaneous |
| Operating Systems |
| Programming |
Re: [NOVICE] A few comparison terms just to be sure.
Date: Sun Jul 01 2007 - 17:54:38 EDT
"Dale Cooper" <sa_dale_cooper@hotmail.com> writes:
> The questions:
> 1- What I know as an oracle database (a group of schemas), in postgresql is
> 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 terminology.)
> 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
---------------------------(end of broadcast)---------------------------TIP 2: Don't 'kill -9' the postmaster Received on Sun Jul 1 17:56:54 2007
This archive was generated by hypermail 2.1.8 : Sun Jul 01 2007 - 18:00:02 EDT
|
Contact Us Legal Notices Order Services Online Pantek Home Privacy Policy IT news Site Map Pantek Library |