PostgreSQL Quick Cheat Sheet
Common MySQL commands in PostgreSQL
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.