Class PostgreSQLStatementParser

    • Method Detail

      • supportsExplain

        protected boolean supportsExplain()
        Indicates whether the parser supports the EXPLAIN clause. The PostgreSQL parser does not support it.
        Specified by:
        supportsExplain in class AbstractStatementParser
      • getQueryParameters

        @InternalApi
        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 AbstractStatementParser.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'

        Parameters:
        sql - the SQL-string to check for parameters. Must not contain comments.
        Returns:
        A set containing all the parameters in the SQL-string.