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

Re: PostgreSQL Guide for Oracle Users?

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: S S <dbapg8(at)yahoo(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: PostgreSQL Guide for Oracle Users?
Date: 2005-04-18 15:45:12
Message-ID: 20050418154512.GA23396@winnie.fuhr.org (view raw or flat)
Thread:
Lists: pgsql-novice
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/

In response to

pgsql-novice by date

Next:From: Tom LaneDate: 2005-04-18 15:58:10
Subject: Re: How to improve postgres performace
Previous:From: Keith WorthingtonDate: 2005-04-18 15:41:18
Subject: text parsing function

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