What options exist to restore tab completion using libedit in PSQL on OS X Lion?
Install macports, and then install the postgresql83 package.

sudo port install postgresql83

The macports psql works fine. Make sure you get it first on your path, e.g.:

PATH=/opt/local/lib/postgresql83/bin:$PATH