Skip to main content
Microsoft Idea

    Power BI

    New

    ODBC Postgresql import connector does not support regex/regular expressions on SQL

    Vote (1) Share
    Chuck Roberts's profile image

    Chuck Roberts on 11 Oct 2022 11:15:09

    We use an ODBC connector and an SQL statement to query a Postgresql database. This connector does not seem to support regex like this:

    "WHERE (jobnum~'^\d+$')"


    I don't even get an error. I think it just pulls zero records.


    Can you have the ODBC connector support regex?

    Comments (1)
    Chuck Roberts's profile image Profile Picture

    Chuck Roberts on 11 Oct 2022 11:16:22

    RE: ODBC Postgresql import connector does not support regex/regular expressions on SQL

    We use this ODBC connector in import mode.