On 1/23/2013 2:56 PM, Scott Ribe wrote:
For a client who needs to learn how to query the db: - No SQL knowledge at all; needs to start from square 1. - Smart, capable person, who will be in this position for a long time, using this db for a long time. - No chance in hell this db will be moved off PG, so PG-centric is fine
I can't recommend any specific book as I've not read any of them (and been doing SQL too long). But what I *can* recommend is creating a 'sql cookbook', maybe on an internal wiki or blog, with a bunch of sample queries specific to YOUR database schema that solve the sorts of problems your user base including this client are likely to come up against. start with the simplest things and move up to more complex. have a paragraph or two explaining each query, and example output.
-- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
