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 — a_horse_with_no_name, May 25 '15 at 07:11

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

20

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,558
6
26
54

Thank you. You're answer was very helpful. – Vajira Lasantha May 25 '15 at 07:13
`\?` is useful! – Carson Jul 09 '20 at 02:10

How can I exit/logout from PostgreSQL?

1 Answers1