Re: OT: PostgreSQL

memset@xxxxxxxxxxxxxx wrote:

> Sorry for being off-topic, but can anybody point me to some good
> PostgreSQL tutorials? I've always used MySQL & would like to venture into
> PostgreSQL.

Hi,

I have been developing on Postgresql my whole PHP life.
I had an easy start by buying the great book: Practical Postgresql by
Worsley and Drake.
By O'Reilly as usual. :-)

Allthough it starts by assuming you have SQL knowledge, it will teach you
all the basics, but it is not a SQL book, but a Postgresql book.
If you are familiar with SQL (which you are because you did a lot on mySQL)
this is a great resource to start with.
Also the online documentation is good, but little educative, and that is
where this books comes in.

I guess there are a lot of other great books out there, but this is the only
one I needed.
It also covers the scriptinglanguage PL/pgSQL to write triggers and stored
functions and such.

Regards,
Erwin Moller

>
> -Mike
>
> --
> Melt away the Cellulite with Cellulean!
> http://www.MeltAwayCellulite.com/

.

Relevant Pages

  • Re: Effect of MySQL being acquired by Sun Micro
    ... PostgreSQL did, so new developers (who only knew how to boot into ... Windows) picked MySQL. ... I didn't know SQL support was added that late. ...
    (comp.lang.php)
  • Re: Python, xml, databases, ...
    ... I think you want to be clear whether you want a database or not. ... Any machine can run a service (such as MySQL or PostgreSQL), ... both MySQL and PostgreSQL rely on the Cygwin dll. ...
    (comp.lang.python)
  • Re: Effect of MySQL being acquired by Sun Micro
    ... PostgreSQL did, so new developers (who only knew how to boot into ... Windows) picked MySQL. ... By the time Postgres became PostgreSQL, mSQL already had a strong foothold ...
    (comp.lang.php)
  • Re: pro- foreign key propaganda?
    ... I had built the DB backend using postgresql. ... reasons decided to switch to MySQL and created his own tables (as well as ... They'd also never leave foreign keys out of their designs, too, I guess. ...
    (comp.databases.theory)
  • Re: Looking for a database
    ... >> The obvious choices on fedora will be MySQL and postgresql ... > If I was to chose between Postgresql and another free database it would ... > be between Postgresql and Firebird, ...
    (Fedora)