mysql> select * from names; +------+-------+ | id | name | +------+-------+ | 1 | Lucho | | 2 | Lily | | 3 | Kiro | +------+-------+ 3 rows in set (0.00 sec) mysql> select * from prof; +-----------+------------+ | person_id | prof | +-----------+------------+ | 1 | Programmer | | 2 | QA | | 3 | Sys admin | +-----------+------------+ 3 rows in set (0.00 sec) mysql> update names inner join prof on..
Javascript: The Good Parts (Chapter 5) -Douglas Crockford Prototypal Inheritance in Javascript -Douglas Crockford Object-Oriented Javascript -Stoyan Stefanov Javascript Override Patterns -Andrea Giammarchi Simple JavaScript Inheritance -John Resig http://alexsexton.com/?p=51
Connect to postresql psql or psql db_name Create a user CREATE USER kevin WITH PASSWORD 'my_password'; Create a user from command line createuser kevin Remove a user from command line dropuser kevin Select database \c db_name Show databases select datname from pg_database; List databases \l Show Schemas \dn Show tables \d Show tables in schema \dt my_schema.* Show all sequences \ds Show all view..