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:

MySQL Postgres

Action MySQLPostgreSQL
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.

Comments

Add your Comments

Feel free to leave a comment about this post.

- Feel Free to add HTML to your comment!