Today before I knew how to exit a psql command prompt in PostgreSQL I used ctrl-z to exit. I wanted to get back into psql so I went to Google to find out how. This time SuperUser.com came to my rescue.

It is as simple as this:

fg

Read the post for other options, but the above is what I needed. Worked like a charm