Thread: PostgreSQL Guide for Oracle Users?
I have been using Oracle for years, but have just started with PostgreSQL. I've downloaded & installed the software (v8.0.2), and I'm slowing reading my way through the manual. Is there any sort of documentation, or a FAQ, or tips/tricks, or just anything that shows differences between Oracle and PostgreSQL? Either from a DBA or from a programmer point of view? Is there something somewhere that will help people familiar with Oracle learn what to do (and also what not to do) in PostgreSQL? For example, it appears that a transaction in PostgreSQL must start with the BEGIN keyword, whereas Oracle implicitly begins a transaction with the first SQL statement issued when you log into the database. Is there anyplace to look for any sort of "PostgreSQL Guide for the Oracle User"? __________________________________ Do you Yahoo!? Plan great trips with Yahoo! Travel: Now over 17,000 guides! http://travel.yahoo.com/p-travelguide
Check this: http://techdocs.postgresql.org/#convertfrom Hope this helps. Sean ----- Original Message ----- From: "S S" <dbapg8@yahoo.com> To: <pgsql-novice@postgresql.org> Sent: Monday, April 18, 2005 11:11 AM Subject: [NOVICE] PostgreSQL Guide for Oracle Users? > > I have been using Oracle for years, but have just > started with PostgreSQL. I've downloaded & installed > the software (v8.0.2), and I'm slowing reading my way > through the manual. > > Is there any sort of documentation, or a FAQ, or > tips/tricks, or just anything that shows differences > between Oracle and PostgreSQL? Either from a DBA or > from a programmer point of view? > > Is there something somewhere that will help people > familiar with Oracle learn what to do (and also what > not to do) in PostgreSQL? For example, it appears > that a transaction in PostgreSQL must start with the > BEGIN keyword, whereas Oracle implicitly begins a > transaction with the first SQL statement issued when > you log into the database. > > Is there anyplace to look for any sort of "PostgreSQL > Guide for the Oracle User"? > > > > > __________________________________ > Do you Yahoo!? > Plan great trips with Yahoo! Travel: Now over 17,000 guides! > http://travel.yahoo.com/p-travelguide > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend >
On Mon, Apr 18, 2005 at 08:11:47AM -0700, S S wrote: > > Is there any sort of documentation, or a FAQ, or > tips/tricks, or just anything that shows differences > between Oracle and PostgreSQL? Either from a DBA or > from a programmer point of view? Looking up "Oracle" in the documentation index yields a link to "Porting from Oracle PL/SQL": http://www.postgresql.org/docs/8.0/interactive/plpgsql-porting.html That might not be as complete as you'd like, but it's something. A search engine like Google might find additional help. > Is there something somewhere that will help people > familiar with Oracle learn what to do (and also what > not to do) in PostgreSQL? For example, it appears > that a transaction in PostgreSQL must start with the > BEGIN keyword, whereas Oracle implicitly begins a > transaction with the first SQL statement issued when > you log into the database. You can make PostgreSQL work this way by disabling autocommit in the client. In psql, for example, you can set the AUTOCOMMIT variable to "off". See the documentation for the client interface you're using. -- Michael Fuhr http://www.fuhr.org/~mfuhr/