I had trouble figuring out how to exit the psql command prompt today in PostgreSQL. After reviewing the docs I found it rather easy. \q (back slash q)