cd /var/run/postgresql

psql -h <DBServer> -p <DBPORT -U <DNUSER -d <DBName> -- ok

COPY TABELNAME FROM 'filename' WITH(DELIMITER'|',ENCODING'UTF8');

make sure the last delimeter just before new row is removed : this cases the error