QA Graphic

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:

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 Comments

Name:
Comment:

 

About

Weekly Tips and tricks for Quality Assurance engineers and managers. All reviews are unbiased and are based on personal use. No money or services were exchanged for the reviews posted.

Schedule

FridayMacintosh
SaturdayInternet Tools
SundayOpen Topic
Monday Media Monday
TuesdayQA
WednesdayKeyboard Maestro
ThursdayGluten Free