The "SET ROLE 'Postgres' "statement cannot be parsed

[step-baby]

test code:

#[test]
    fn test_sql() {
        let dialect = PostgreSqlDialect {};
     
        let sql = "SET ROLE 'postgres'";
        Parser::parse_sql(&dialect, sql).unwrap();
    }

result:

called `Result::unwrap()` on an `Err` value: ParserError("Expected equals sign or TO, found: 'postgres'")
thread 'interceptor::pg::tests::test_sql' panicked at 'called `Result::unwrap()` on an `Err` value: ParserError("Expected equals sign or TO, found: 'postgres'")'

[alamb]

Thanks for the report @YJX051212 -- please feel free to submit a PR to fix this issue

[slhmy]

Hi 👋, interesting in this topic.
I will follow this doc and raise a PR.
https://www.postgresql.org/docs/13/sql-set-role.html

[alamb]

Thanks @slhmy