def METHOD_NAME(url):
    parse_result = urlparse(url)
    if parse_result.scheme == 'postgresql+psycopg2':
        q = parse_qs(
            parse_result.query.replace('%%', '%')
        )
        options = q.get('options')
        if options and len(options) >= 1:
            params = options[0].replace('-c ', '').split(' ')
            kvs = dict(p.split('=') for p in params)
            return kvs.get('search_path')