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
