| July 16, 2018 |
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:
| Action | MySQL | PostgreSQL |
|---|---|---|
| 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.
Filed under the "QA" category.
Comments
Add your Comments
Feel free to leave a comment about this post.