Re: table design - Mailing list pgsql-novice

From Mike Adams
Subject Re: table design
Date
Msg-id 4DF57AA3.6020204@comcast.net
Whole thread Raw
In response to Re: table design  (Matt <urlugal.mailinglists@gmail.com>)
List pgsql-novice
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 2011-02-14 07:25, Matt wrote:
>
>
> I have a few books and have been slowly making my way through
> them and the combination of them and trial and error to see what
> works and what doesn't has proved to be the best way. The ones
> I found helpful for me anyway are "SQL and Relational Theory" by
> CJ Date, The Postgres Documentation, and "The Theory Of
> Relational Databases" David Maier.
>

Now, both of those books are VERY good, but for design from scratch...
give:


http://www.amazon.com/Database-Design-Mere-Mortals-Hands/dp/0201752840

a try, I thought it rather well thought out.

Also read Celko (any and all):


http://www.amazon.com/Joe-Celko/e/B000ARBFVQ/ref=sr_tc_ep?qid=1307931971


Enjoy,
- --
Michael Adams
SQL/Perl/VBA/C??/Java
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.17 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk31eqMACgkQFUo+7qhKZejTtQCeK/n6CK2rsq09lRMOyEKjUXCA
GhAAoM7A0RYR8sPupRWv0E5ZZAo4HkXZ
=8eTw
-----END PGP SIGNATURE-----



-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1382 / Virus Database: 1513/3699 - Release Date: 06/12/11


pgsql-novice by date:

Previous
From: "Jean-Yves F. Barbier"
Date:
Subject: Re: images in one or more tables?
Next
From: Francisco Leovey
Date:
Subject: Need a SQL to find if table has OIDS