postgresql

psql.txt

\?                                          -> help
create database JAMON;                      -> create DB              | alternative: $ createdb JAMOM
\l                                          -> list db's
drop database JAMON;                        -> drop DB
\q                                          -> exits
\c JAMON                                    -> switch over DB
\d TABLE?                                   -> describe DB or TABLE
create table NAME(\n column TYPE, ...);     -> start modeling table
SERIAL, TEXT                                -> column types
insert into TABLE(column) values('value');  -> fill the table
select * from TABLE;                        ->