How to exit from PostgreSQL command line utility: psql

PostgresqlPostgresql 9.1Psql

Postgresql Problem Overview

What command or short key can I use to exit the PostgreSQL command line utility psql?

Postgresql Solutions

Solution 1 - Postgresql

Type \q and then press ENTER to quit psql.

UPDATE: 19-OCT-2018

As of PostgreSQL 11, the keywords "quit" and "exit" in the PostgreSQL command-line interface have been included to help make it easier to leave the command-line tool.

Solution 2 - Postgresql

My usual key sequence is:

quit()
quit
exit()
exit
q
q()
!q
^C
help
Alt + Tab
google.com
Quit PSQL
\q

I think veterans of the psql command line usually shorten that to just:

\q

Solution 3 - Postgresql

Ctrl+D is what I usually use to exit psql console.

Solution 4 - Postgresql

Use:

  • Ctrl+Z - this sends the TSTP signal (TSTP is short for “terminal stop”)
  • Ctrl+\ - this sends the QUIT signal

For curiosity:

  • Ctrl+D - this sends the EOF character. EOF stands for "end of file". In this concrete case it exits from the psql subprogram, as the shell is waiting for user input. This should not be 'the way to go' as it is not working if:
  • any other character is entered before - try entering some white spaces and then press Ctrl+D, it's not going to exit psql.
  • if the user input is not required at all

Solution 5 - Postgresql

quit or exit or \q

Based on PostgreSQL 11 Beta 1 Released!:

> # User Experience Enhancements > > Another feature that fell into this category was the inability to intuitively quit from the PostgreSQL command-line (psql). There has been numerous recorded complaints of users trying to quit with the quit and exit commands, only to learn that the command to do so was \q. > > We have heard your frustrations and have now added the ability to quit the command-line using the keywords quit and exit and hope that quitting a PostgreSQL session is now as enjoyable as using PostgreSQL.

Solution 6 - Postgresql

I learned that I could include \q in a batch .sql file, so I could have psql quit earlier from an \i operation.

Solution 7 - Postgresql

For Linux command line \q + enter.

Quiting with Ctrl + D also is works

Solution 8 - Postgresql

Actually, \q, exit and CTRL + D did'nt worked for me to exit from the psql program.

Ctrl + Shift + D

Worked for me. Hope it ll help someone :)

My ubuntu version is 19.04

Categories
Recommended Postgresql Solutions
Recommended Postgresql 9.1 Solutions
Recommended Psql Solutions

Previous Solution:

What is the difference between an interface and abstract class?

OopInterfaceAbstract Class

Next Solution:

Delete a column from a Pandas DataFrame

PythonPandasDataframe

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionApp WorkView Question on Stackoverflow
Solution 1 - PostgresqlFranklineView Answer on Stackoverflow
Solution 2 - PostgresqlTedView Answer on Stackoverflow
Solution 3 - PostgresqlKaarelView Answer on Stackoverflow
Solution 4 - PostgresqliustingView Answer on Stackoverflow
Solution 5 - PostgresqlLukasz SzozdaView Answer on Stackoverflow
Solution 6 - PostgresqlsflitmanView Answer on Stackoverflow
Solution 7 - PostgresqlMaurice ElaguView Answer on Stackoverflow
Solution 8 - PostgresqlVinoCoderView Answer on Stackoverflow