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
>