Tired of those wide tables that wrap? You can end your query with a \G to get output like this:

mysql> select * from users\G
*************************** 1. row ***************************
     id: 1
   name: xinu
created: 20050115210745
*************************** 2. row ***************************
     id: 2
   name: cygnus
created: 20050115210803
2 rows in set (0.00 sec)

In your ~/.psqlrc, add this to emulate MySQL-style borders in query results:

\pset border 2

If you want to see how long a query is taking to run, you can either run explain analyze or enable timing for the client by typing \timing.