Faced an interesting error while accessing postgres table with a simple java code.
"select * from User"
A little googling revealed that if you are using multicase table name (U is caps), you will need to give the table name in quotes.
A better fix would be to always use lower case characters when declaring tables in postgres.
I was trying to install postgres 9 on my Ubunto 11.04 machine, but the GUI installer simply hanged. A little bit of googling provided the workaround.
Follow the steps
1. sudo apt-get install python-software-properties
2. sudo add-apt-repository ppa:pitti/postgresql
3. sudo apt-get update
4. sudo apt-get install postgresql-9.0 libpq-dev
Source
http://www.dctrwatson.com/2010/09/installing-postgresql-9-0-on-ubuntu-10-04/