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: (view raw, whole thread or download thread mbox)
Lists: pgsql-general

(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:

Concurrency control:


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 

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
>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.)
>---------------------------(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-2017 The PostgreSQL Global Development Group