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:
[email protected]:/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”:
[email protected]:/home/postgres/ [PGDEV] psql -X postgres psql (11devel) Type "help" for help. postgres=# quit [email protected]:/home/postgres/ [PGDEV]
… or “exit”:
[email protected]:/home/postgres/ [PGDEV] psql -X postgres psql (11devel) Type "help" for help. postgres=# exit [email protected]:/home/postgres/ [PGDEV]
I am pretty sure MacBook users will love that 🙂
vi, mail and other applications may have differences between exit and quit.
psql will interpret both commands with an implicit rollback.
i prefer the keycode ctrl-d to simulate an end-of-file.
Hi Maletin,
thanks for adding that information. I personally also prefer CRTL-D but I heard others feel that is nasty 🙂
Cheers,
Daniel
I can’t believe you left out:
postgres=# ^C
postgres=# ^C
postgres=# ^C
postgres=# ^C
postgres=# ^C
Yeah, that is another one 🙂 Thx