On Aug 30, 2006, at 6:29 AM, Pantelis Natsiavas wrote:
> In addition trying to make the same query through the query tool
> of pgadmin, I receive the same answer and of course null results. I
> don't know if it matters, but I am using Windows XP and PostgreSQL
> 8.1 with JDBC 3. I have checked everything that has to do with the
> java part of encoding and I cannot find anything wrong. The fact
> that I could not make the query through the pgadmin query tool,
> shows that the problem lays at the PostgreSQL part.
> What could I do? Can anyone help me?
A few issues to check:
1. pgadmin will double quote table names that have special
characters, mixed case, or reserved words. So double check the exact
table name and perhaps try double quoting it in your query.
2. Be sure your table's schema is on the search_path.
3. Double check the value of client_encoding.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL