-
Frequently used commands in Postgres database with psql command line tool
almost 10 years ago
almost 10 years ago
Connect to local server using psql command line tool with postgres user.
sudo -u postgres psql postgres
To set/change password of postgres user
\password
To check/list all databases
\list or \l
To see/list all tables in current database
\dt
Switch to Databases
\connect database_name
0 Comment(s)