###Useful PG & MYSQL command line interface commands:
| database | enter CLI | exit CLI | table | databases | change databases | columns | describe |
|---|---|---|---|---|---|---|---|
| mysql | mysql |
exit |
SHOW TABLES |
SHOW DATABASES |
use database_name |
SHOW COLUMNS |
DESCRIBE TABLE |
| postgresql | psql |
\q |
\d |
\l |
\c database_name |
\d table |
\d+ table |
To check our port is up and running with Postgres:
netstat -lan | grep 5432