Using Postgresql on Ubuntu

Jan 18, 2018 • Arne Vogel

Logging into psql as postgres user:

sudo -u postgres psql

Switching databases:

\c [DB NAME]

Executing an example query:

SELECT * from user;

Note that SELECT has to be capitalized, otherwise it will result in a syntac error. Also don’t forget the ; at the end of the query.

Exiting psql: