Peter(dot)Rupp(at)ual(dot)com writes:
> When using either interface, I notice that when I select rows from a
> table, it appears that the client interface retrieves the entire
> results set at once...and loads it into memory on the client machine.
The standard answer is to use a cursor and FETCH a few rows at a time.
> Do you folks publish the network symantics and protocols used to
> make sql requests and retrieve their results?
http://developer.postgresql.org/docs/postgres/protocol.html
regards, tom lane