drop table PLAYERS cascade;
drop table TEAMS cascade;
drop table SALARIES cascade;

create table PLAYERS(playerID varchar(20), first_name varchar(50), last_name varchar(50), rightHanded varchar(1));

create table TEAMS(yearID integer(4), teamID varchar(20), teamName varchar(100), stadium varchar(100));

create table SALARIES(year integer(4), teamID varchar(20), playerID varchar(20), salary integer(10));

copy PLAYERS from 'players.csv' delimiters ',';

copy TEAMS from 'teams.csv' delimiters ',';

copy SALARIES from 'salaries.csv' delimiters ',';