How to select a Postgres Schema?

[contibru]

Describe the bug

I have created all the quartz tables in a schema different from "public" and now when the application starts, it not recognizes the tables.
Is there a way to set the schema that quartz should use?

Error:

Quartz Configuration:

public static IServiceCollection AddQuartzServices(this IServiceCollection services, string connectionString)
        {
            services.AddQuartz(q =>
            {   
                q.UseMicrosoftDependencyInjectionJobFactory();
                q.UsePersistentStore(s =>
                {
                    s.PerformSchemaValidation = false; // default
                    s.UseProperties = true; // preferred, but not default
                    s.RetryInterval = TimeSpan.FromSeconds(15);
                    s.UsePostgres(postgres =>
                    {
                        postgres.ConnectionString = connectionString;
                    });
                    s.UseJsonSerializer();
                });
            });
            services.AddQuartzHostedService(opt =>
            {
                opt.WaitForJobsToComplete = true;
            });

            return services;
        }

Version used

3.6.2

To Reproduce

Ideally code samples or event unit test.

Expected behavior

A clear and concise description of what you expected to happen.

Additional context
Add any other context about the problem here.

[lahma]

I believe that you should use table prefix configuration for this.

[contibru]

I have tried e still not working, I don`t believe this syntax is right for Postgres:

[jafin]

https://www.quartz-scheduler.net/documentation/quartz-3.x/configuration/reference.html#quartz-jobstore-tableprefix

[contibru]

I have tried e still not working, I don`t believe this syntax is right for Postgres:

[contibru]

@jafin and @lahma
It worked without the "[]", I changed to :

postgres.TablePrefix = "hh_tro_schd.qrtz_";

Thanks for the help!