Mike's Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

======= CLI Commands and Equivalents =======

**This is a work in progress**


^ Command ^ Oracle ^ MySQL  ^ Postgres ^
| Show databases (schema) |<code>select distinct owner 
from dba_objects 
where owner =' '</code>| 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> |