Go to the site-packages directory where pip is installing your packages.
You should see the egg file that corresponds to the package you want to uninstall. Delete the egg file (or, to be on the safe side, move it to a different directory).
Do the same with the package files for the package you want to delete (in this case, the psycopg2 directory).