https://prefect.io logo
Title
a

Amol Shirke

08/25/2022, 12:07 PM
Hello, What postgress schema does prefect 2.0 use? Can we use different. Schema?
1
c

Christopher Boyd

08/25/2022, 1:51 PM
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
r

Ryan Peden

08/25/2022, 2:10 PM
Amol, just to clarify: are you asking about the Postgres schema name Prefect uses?
a

Amol Shirke

08/25/2022, 2:14 PM
Yes I like to know what schema name prefect uses?
I am having issue as in setup we don't have public schema and we have to create one and use it.
r

Ryan Peden

08/25/2022, 3:10 PM
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
).
z

Zanie

09/24/2022, 2:28 AM
We should put this in the docs