Postgres

gistfile1.txt

A cluster is a group of databases runing on the same server;
- `COPY tablename FROM '/home/user/weather.txt'` *inserts* rows from the given file to `tablename`; [Copy](http://devdocs.io/postgresql~9.6/sql-copy)

A cluster is a group of databases runing on the same server;

• COPY tablename FROM '/home/user/weather.txt' inserts rows from the given file to tablename; Copy

Requests:

• 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, temp_lo;
• SELECT DISTINCT city FROM weather ORDER BY city;