PostgreSQL Quick Cheat Sheet
If your use to supporting MySQL and now having to support PostgreSQL it can be tricky to know some of the common admin commands.
Here's a handy chart that I quickly put together of common admin commands that are used between the two databases:
|List databases||Show databases||l|
|Connect to database||use database;||c database|
|Show Database Tables||Show Tables||d|
|Show Tables Columns||Show Columns||d table|
If there are any other commands you want to add, let me know in the comments below.
Add your Comments
Feel free to leave a comment about this post.