SysAdmin Tips, Tricks and other Software Tools
Primary Key setup: http://www.techonthenet.com/postgresql/primary_keys.php