Using Psql On The Command Line To Examine PostgreSQL Databases

Posted by Weston Ganger on April 15, 2015

I keep finding myself looking for this information so I have started compiled a cheatsheet of psql commands. Enjoy.

$ psql postgres

\l #show all databases
\c databaseName #switch databases
\dt #show all tables in current database
\d+ tableName #show schema of tableName in current database
\du #show all users
create database databaseName; #create database
drop database databaseName; #drop database
\q #quit

ALTER USER myuser WITH SUPERUSER; #make user a superuser
ALTER USER myuser WITH NOSUPERUSER; #remove superuser from user

Posted in Linux and Tagged with psql postgres database 

Want me to help develop your next project or application?

Contact Us

Specializing in Ruby-on-Rails, Javascript, Multi-Platform Electron Desktop Apps and Hybrid Cordova Mobile Apps.

Recommended Posts