Query returns results on pgAdmin running on remote client but not directly through psql on db server
Found the resolution to my issue. To check query results you need to terminate every query in psql with a semicolon ;. If the semicolon is not used you don't see the query result when using the psql command line.

Quote from the manual


  Entering SQL Commands
  
  ...
  
  At the prompt, the user can type in SQL commands. Ordinarily, input lines are sent to the server when a command-terminating semicolon is reached. An end of line does not terminate a command. Thus commands can be spread over several lines for clarity.