public class PostgreSQLStatementParser extends AbstractStatementParserMethods
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 |
Stringthe 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 |
|