Query in PGNP returns different results than PGadmin?

Hi: I'm evaluating PGNP trial version. I have a connection to a remote PostgreSQL server that works in PGAdmin, and is also working to set up a linked server is SSMS. In SSMS linked server I'm using the "Intellisoft OLE DB Provider for PostgreSQL" with the same server, port, dB and username as in PGAdmin.

When I query a db table in PGAdmin, I get the expected results, but when I execute the same query using the [server].[db].[schema]. in SSMS, I am seeing different data...what looks like older data. How is this possible?

Is it possible that the schema is different between the two applications?

This could be caused by the Trial limitations, specifically - the Trial returns upto 100 rows. To check if that is the case, please add ORDER BY and LIMIT 100 clauses to the query. Then result should be the same as from the pgAdmin.

Thank you...this was indeed the issue. My query had a number of joins on tables with > 100 rows, so I was not finding the data I needed because each join only queried the first 100 rows of each table. I was able to use CTEs to narrow the result sets and join the relevant data.