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
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
