Table of Contents

CLI Commands and Equivalents

This is a work in progress

Command Oracle MySQL Postgres
Show databases (schema) 
select distinct owner 
from dba_objects 
where owner =' '
 show databases \l
Query Buffer list <up arrow > \p
Quit / Exit exit exit \q
Display users select * From dba_users; \du
Display Schemas <same as show databases> \dn
Connect to a new DB . connect database
Dropping a schema drop user <username> cascade drop database <database_name> drop schema <schema_name> cascade; ←- Will drop the schema and all objects
Show all tables select * From dba_tables where owner = <owner> show tables \dt+ <schema_name>.*

Privs

Command Oracle MySQL Postgres
create user create user <username> identified by <password>; Same as Oracle Create user <username> password <password>;

Dumping and Restoring

Command Oracle MySQL Postgres
dumping expdp mysqldump pg_dump
Restore impdp mysql > source <file_name> psql > \i <file_name>