Dear Danny,
Could you try pgAdmin2 and enter 'SET CLIENT_ENCODING = ISO-8859-8'. Then try
to display data in pgAdmin2. Does it work?
Information can be found at
http://developer.postgresql.org/docs/postgres/multibyte.html#AEN16680
Cheers,
Jean-Michel POURE