Re: [JDBC] query

Chuck Davis <cjgunzel@gmail.com> writes:
> If I execute the select statement in psql it works as expected:
> ...
> If I execute the statement in my program (and this has been working for
> years on DB2) I get the following exception:
>  org.postgresql.util.PSQLException: ERROR: relation "infosys.company" does
> not exist

I'd lay pretty long odds that that means the program is connecting to a
different database than you're connecting to in psql.  Double-check the
connection URL it's using.

(A common variant of that is "program is using a different search_path",
but since you're failing on a schema-qualified relation name, search
path doesn't enter into it.)

            regards, tom lane