When giving the PostgreSQL DBA Essentials workshop one of the main issues people have is how they can exit psql. Even on stackoverflow this is a popular topic. The good news for people who still don’t like to use “q” here is the commit that will add additional options to quit/exit from psql.
Up to PostgreSQL 10 what you can usually see is something like this:
postgres@pgbox:/home/postgres/ [PG10] psql -X postgres psql (10.0) Type "help" for help. postgres=# exit postgres-# exit postgres-# quit postgres-# let me out, what do I need to to? postgres-#
Starting with PostgreSQL 11 you can either use “quit”:
postgres@pgbox:/home/postgres/ [PGDEV] psql -X postgres psql (11devel) Type "help" for help. postgres=# quit postgres@pgbox:/home/postgres/ [PGDEV]
… or “exit”:
postgres@pgbox:/home/postgres/ [PGDEV] psql -X postgres psql (11devel) Type "help" for help. postgres=# exit postgres@pgbox:/home/postgres/ [PGDEV]
I am pretty sure MacBook users will love that 🙂