Class PostgreSQLStatementParser 

public class PostgreSQLStatementParser extends AbstractStatementParser

Inheritance

java.lang.Object > AbstractStatementParser > PostgreSQLStatementParser

Methods

getQueryParameters(String sql)

public Set<String> getQueryParameters(String sql)

Note: This is an internal API and breaking changes can be made without prior notice.

Returns the PostgreSQL-style query parameters ($1, $2, ...) in the given SQL string. The SQL-string is assumed to not contain any comments. Use #removeCommentsAndTrim(String) to remove all comments before calling this method. Occurrences of query-parameter like strings inside quoted identifiers or string literals are ignored.

The following example will return a set containing ("$1", "$2"). select col1, col2, "col$4" from some_table where col1=$1 and col2=$2 and not col3=$1 and col4='$3'

Parameter
Name Description
sql String

the SQL-string to check for parameters. Must not contain comments.
Returns
Type Description
Set<String>

A set containing all the parameters in the SQL-string.

supportsExplain()

protected boolean supportsExplain()

Indicates whether the parser supports the EXPLAIN clause. The PostgreSQL parser does not support it.

Returns
Type Description
boolean
Overrides