How can I exit/logout from PostgreSQL?

Question

I'm new to psql and using psql command line on Ubuntu. What is the command to logout/exit from command line?

Thank you!

This is all documented in the manual: http://www.postgresql.org/docs/current/static/app-psql.html — , May 25 '15 at 07:11

inquisitive · Accepted Answer · 2015-05-25T07:15:20.210

21

type \q and press enter to quit from psql from command line. In general the meta commands are preceded by \ for eg- \list or \l: list all databases or \dt: list all tables in the current database

To switch databases:

\connect database_name

If that does not work, you can use CTRL + D. For more help on meta commands you can press \?

Since you are new to psql consider referring to the documentation here

edited May 25 '15 at 07:15

answered May 25 '15 at 06:20

inquisitive

3,738
6
30
56

`\?` is useful! – Carson Jul 09 '20 at 02:10

How can I exit/logout from PostgreSQL?

1 Answers1