###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: