Re: PostgreSQL Guide for Oracle Users?

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/