PostgreSQL Vs MySQL differences in syntax - side by side comparison cheatsheet for show databases, tables, schemas and more

Mani
Mani
Educating everyone with the beauty of programming!!
PostgreSQL Vs MySQL differences in syntax - side by side comparison cheatsheet for show databases, tables, schemas and more

PostgreSQL Vs MySQL Syntax Comparison - Cheatsheet for databases, tables, schemas

In the previous post for PostgreSQL Vs MySQL Syntax Comparison - Useful basic commands with examples , we compared the detailed differences between PostgreSQL vs MySQL syntax. If you haven’t read it already we strongly recommend to read that post before going through this cheatsheet as it has more detailed examples with basic command usage for postgres and mysql.

As a handy reference, here is the cheatsheet for PostgreSQL vs MySQL syntax comparison highlighting the differences.

How to PostgreSQL MySQL
Show list of databases \l show databases
Use database \c {db_name} use {db_name}
Show list of schemas \dn show schemas
Show list of tables \d or \d+ or \dt or \dt+ show tables
Describe table \dt {table_name} or \d+ {table_name} describe {table_name}
Show create table pg_dump -st {table_name} {dbname} show create table {table_name}
Show list of users or roles \du SELECT User, Host from mysql.user;
Show process list select * from pg_stat_activity show processlist
Comment single line -- (double dash) # (hash)
String quotes Only supports single quote (') eg:`where name = 'TipSeason'` Supports both single(') and double quotes (") eg: `where name = "TipSeason"`
Case sensitivity Postgres is case sensitive eg: `WHERE name = 'TipSeason'` gives different results than `WHERE name = 'tipseason'` MySQL is case insensitive.



We hope you like this post. If you have any questions or suggestions or need any other additional info, please comment below.

We have started a coding community for most frequently used real world coding tips. You can join us here
TipSeason Facebook Group
TipSeason Discord channel
As a bonus, here is a simple tech tip to increase your productivity.

What do you want to learn next ? Drop a comment below!