Connecting to Remote DB with psql

psql -h host.crap.com -U user_name -d database_name

For more options, see the postgres manual: http://www.postgresql.org/docs/8.1/interactive/app-psql.html