lin/1-command.md

Last active January 25, 2017 11:57

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/lin/90b3e4d15e4060790ac71381c96f2296.js"></script>
Save lin/90b3e4d15e4060790ac71381c96f2296 to your computer and use it in GitHub Desktop.

Download ZIP

Postgresql

Raw

1-command.md

one: how to assign different priorities. two:

===========

1, createdb
2, dropdb
3, psql \h (help) \q (quit)

Raw

2-sql.md

CREATE TABLE weather ();
DROP TABLE weather;

INSERT INTO weather VALUES ();
INSERT INTO weather () VALUES ();

SELECT * FROM weather;
SELECT city, temp_lo, temp_hi, prcp, date FROM weather;
SELECT city, (temp_hi+temp_lo)/2 AS temp_avg, date FROM weather;
SELECT * FROM weather WHERE city = 'San Francisco' AND prcp > 0.0;
SELECT * FROM weather ORDER BY city;
SELECT DISTINCT city FROM weather;