>Oh, I realize I was putting the 'E' in the wrong place:
Well yes, but that was not what caused the error. It was the quote.
If you use COPY (or \copy from psql without superuser rights) you can use TABs to delimit the input. Escaping quotes not necessary, unless your text also contains tabs.
Also, quote_literal(text) can come in handy, but in different scenario's.
cheers,
WBL
--
"Patriotism is the conviction that your country is superior to all others because you were born in it." -- George Bernard Shaw