postgresql psql commands

database |Command|Desc| |-------|-----| | \dt or \d |show all tables| | \s | show command history| | \d+ table1 |show table schema| | \c database1 | get new connection for database1 . It means that use database1.| | DROP TABLE table1; | Remove table1 table. Case is sensitive. Don't forget end with a semicolon.| | SELECT * FROM table1; | Show tabl1 content |

cf. https://www.postgresql.org/docs/current/app-psql.html#APP-PSQL-META-COMMANDS