I have been working on porting some Oracle DB code to Postgres, and I am noticing some nomenclature differences (Schemas vs Databases) etc. What are some good resources for dealing with these gotchas? Any tips? What needs to be kept in mind?
A:
Just take a look at the wiki What do you mean by "schemas vs databases" ? PostgreSQL does have schema's, just like databases. By default it doesn't have a schema for every user, but that's up to you.
Frank Heikens
2010-02-25 21:39:50
Does Oracle have the concept of different databases in the same server instance?
Grasper
2010-02-25 21:41:42
@Grasper. Oracle uses the following terminology -- a database is a set of files. An instance is the running software which manages the database. Multiple instances can access the same database (think Oracle's clustering), but no instance can manage multiple databases.
Adam Musch
2010-02-25 21:59:59
It sounds to me like he is referring to the article I wrote about Pg vs MySQL on wikipedia years ago. http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems#Databases_vs_Schemas_.28terminology.29 If he is, this is pretty specific to MySQL. The part in there about Oracle was not part of my original submission to wikipedia.
Evan Carroll
2010-02-26 20:32:10