Hello, What postgress schema does prefect 2.0 use? Can we use different. Schema?

Hi Amol, is there an issue you are trying to solve with doing this? Prefect 2 comes with SQLite by default and I think you can get the base schema from there, I’m not 100% sure if it’s openly shared, but I can try to find out

Amol, just to clarify: are you asking about the Postgres schema name Prefect uses?

Yes I like to know what schema name prefect uses?

I just tested and verified that Prefect 2 will use whichever schema is the default for the user you specify in the connection string (which you can change by altering the Postgres user's

search_path

). But note that the Postgres schema you use will need to have the pg_trgm extension added (or it needs to be added to another schema that is included in the user's

search_path

).

We should put this in the docs