I am currently looking for a software/web development job preferably as a Rails-based developer.
Please email me at email@example.com. Thanks in advance for any leads!
Using Psql On The Command Line To Examine PostgreSQL Databases
Posted by Weston Ganger
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