-- Download the demo file using:
-- curl -L http://ai.wu.ac.at/~polleres/teaching/DOSA_2014/20140505/GradesDemo.csv -o GradesDemo.csv
-- ... or just save it from your Web-browser.

CREATE TABLE grades_raw ( MatNr integer, Name varchar(50), LVNr integer, LVTitel varchar(100), Semester char(6), LVLeiter varchar(50), Note integer );

-- CSV importieren:

\COPY grades_raw FROM 'GradesDemo.csv' WITH DELIMITER ',' CSV HEADER

SELECT * FROM grades_raw;

INSERT INTO grades_raw values ( 1234567, 'Goofy', 1234, 'Linux Basics','SS2014','D. Duesentrieb',1);

UPDATE grades_raw SET Note = 2 WHERE matnr=1234567;

DELETE FROM grades_raw WHERE matnr = 1234567;