\COPY movie (id, name, year) FROM 'movie.txt' WITH( DELIMITER '|', NULL '');
Command like this is also works. It can have more than one option.