Copy from CSV

CREATE TABLE _import_prices_findmtg (card_name VARCHAR(128), edition VARCHAR(4), price NUMERIC(50,2), price_date DATE);ALTER TABLE _import_prices_findmtg OWNER TO magic;SET DATESTYLE='MDY';--SHOW DATESTYLE;COPY _import_prices_findmtg FROM E'c:\\work\\mtg_prices_zen_22_2_2010.csv' DELIMITER ',' CSV;