Thread: PostgreSQL Guide for Oracle Users?

PostgreSQL Guide for Oracle Users?

From
S S
Date:
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

Re: PostgreSQL Guide for Oracle Users?

From
"Sean Davis"
Date:
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
>


Re: PostgreSQL Guide for Oracle Users?

From
Michael Fuhr
Date:
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/