Skip site navigation (1) Skip section navigation (2)

Re: books/sites for someone really learning PG's advanced

From: Paul Tillotson <pntil(at)shentel(dot)net>
To: Miles Keaton <mileskeaton(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: books/sites for someone really learning PG's advanced
Date: 2004-09-24 18:39:11
Message-ID: 415469CF.4040808@shentel.net (view raw or flat)
Thread:
Lists: pgsql-general
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
>
>
>  
>


In response to

pgsql-general by date

Next:From: Tom LaneDate: 2004-09-24 18:40:48
Subject: Re: pg_dump: what is advantage with schema and data dumps?
Previous:From: Ed L.Date: 2004-09-24 17:52:59
Subject: Re: 8.0 logging question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group