Miles,
(Just like someone else also commented), I was in a situation like
yours, and I found the postgres online documentation quite helpful. I
wouldn't read it cover-to-cover yet, but eventually you will want to
read every part of it.
Here is what I found particular helpful at the start:
SQL commands:
http://www.postgresql.org/docs/7.4/static/sql-commands.html
Concurrency control:
http://www.postgresql.org/docs/7.4/static/mvcc.html
Triggers:
http://www.postgresql.org/docs/7.4/static/triggers.html
Note that the section on triggers is a bit sparse, but you can see alot
of examples of triggers and their use by looking through the various
pages about pl/pgsql, pl/perl, etc. (which follow the section about
triggers)
Paul Tillotson
Miles Keaton wrote:
>I'm switching to PostgreSQL from MySQL. Using the SAMs book called
>PostgreSQL which has been great to skim the surface of the
>differerences.
>
>I had never even heard of things like triggers, views, and foreign keys before.
>
>Any recommended books or websites (or exercises) that would really
>help someone get to know not just the basics of how these advanced
>features work, but some real in-depth insight into how to USE them for
>real work?
>
>(It's always hard to get used to actually using features you never
>knew existed before.)
>
>Thanks!
>
>---------------------------(end of broadcast)---------------------------
>TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>
>
>
>
