It is my understanding from the PG documentation that a temporary table
lasts until the end of the session.
When using jdbc, which one of
Connection con = DriverManager.getConnection(...)
or
PreparedStatement sql = con.prepareStatement(...)
actually opens a connection to the PG server?
What if I'm using poolmanager? When will the table be removed? (Because if
session==connection, con.close() in my servlet just returns the connection
to the pool, but the PG server sees the session still open.)
Thank you all.