Thread: Postgresql, SQL server and Oracle. Please, help

Postgresql, SQL server and Oracle. Please, help

From
"Nadia Kunkov"
Date:
Hi, I was wondering where can I get documentation and especially examples on PgSQL?  I've done a lot of work with Ms
SQLserver and need to rewrite a number of stored procedures in PgSQL.  Is there a tutorial?  What is the best way to
start?
Can I read an Oracle book?  How close is Oracle to Postgresql?
Thanks



Re: Postgresql, SQL server and Oracle. Please, help

From
felix@crowfix.com
Date:
On Tue, Jan 25, 2005 at 12:35:50PM -0500, Nadia Kunkov wrote:

> Hi, I was wondering where can I get documentation and especially examples on PgSQL?  I've done a lot of work with Ms
SQLserver and need to rewrite a number of stored procedures in PgSQL.  Is there a tutorial?  What is the best way to
start?
> Can I read an Oracle book?  How close is Oracle to Postgresql?

Not specifically what you want, but there's a book with the
imaginative name of "SQL" by Chris Fehily, Peachpit Press, ISBN
0-201-11803-0, meant as a beginner's guide, but which also includes
all the variations in SQL for PostgreSQL, Oracle, and MS SQL Server.
That is why I got it, and it is pretty handy for me, a non-guru.

--
            ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._.
     Felix Finch: scarecrow repairman & rocket surgeon / felix@crowfix.com
  GPG = E987 4493 C860 246C 3B1E  6477 7838 76E9 182E 8151 ITAR license #4933
I've found a solution to Fermat's Last Theorem but I see I've run out of room o

Re: Postgresql, SQL server and Oracle. Please, help

From
John DeSoi
Date:
On Jan 25, 2005, at 12:35 PM, Nadia Kunkov wrote:

> Hi, I was wondering where can I get documentation and especially
> examples on PgSQL?  I've done a lot of work with Ms SQL server and
> need to rewrite a number of stored procedures in PgSQL.  Is there a
> tutorial?  What is the best way to start?
> Can I read an Oracle book?  How close is Oracle to Postgresql?

Just posted moments ago for a different thread:

On Jan 23, 2005, at 10:22 PM, Duffy House wrote:

> The first issue will be getting up to speed on PL/pgsql.  Where can I
> find
> primer on PL/pgsql, with lots of examples? How silimar is PL/pgsql to
> PL/SQL
> under Oracle?

The PostgreSQL documentation is the place to start:

http://www.postgresql.org/docs/8.0/interactive/plpgsql.html

The PostgreSQL distribution has a file with some examples in it:

src/test/regress/sql/plpgsql.sql

The pgEdit distribution (http://pgedit.com/download) has a fairly
extensive plpgsql example for importing and analyzing web server logs.

I'm not familiar with Oracle, but there is a porting section in the
documentation:

http://www.postgresql.org/docs/8.0/interactive/plpgsql-porting.html



John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL