Postgresql, SQL server and Oracle. Please, help
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?
Thanks
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 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?
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
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