PostgreSQL: create table from CSV

Import CSV data into new table.

1 2 3 4 5

create table shared_db.dt_ranking (ranking_id bigserial, vers text,tadig_code text ,mcc text ,mnc text ,advanced int, lite int, vplmn_rank int,    constraint dt_ranking_pkey primary key (ranking_id) )    \copy shared_db.dt_ranking (vers,tadig_code,mcc,mnc,advanced,lite,vplmn_rank) from '/tmp/ranking.csv' with (format csv, delimiter ',', header true);