July 16, 2018 |
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.
Feel free to leave a comment about this post.