Query

• Calling Stored Functions and Procedures PostgreSQL® supports two types of stored objects, functions that can return a result value and - starting from v11 - procedures that can perform transaction …
• JDBC escapes The JDBC specification (like the ODBC specification) acknowledges the fact that some vendor specific SQL may be required for certain RDBMS features. To aid …
• Getting results based on a cursor By default, the driver collects all the results for the query at once. This can be inconvenient for large data sets so the JDBC driver provides a means of …
• Server Prepared Statements Motivation The PostgreSQL® server allows clients to compile sql statements that are expected to be reused to avoid the overhead of parsing and planning the …
• Using the Statement or PreparedStatement Interface Any time you want to issue SQL statements to the database, you require a Statement or PreparedStatement instance. Once you have a Statement or PreparedStatement …