Newbie in what sense?
Are you an experienced database administrator looking at postgreSQL for a new project?
Are you an experienced programmer, coming to postgreSQL as an option for your first project with three tiered architecture?
Are you new to programming and want to learn to database?
Are you new to databases and expect them to be pretty much like word processors and spreadsheets?