Hi team In Prefect Orion how to specific postgres connection

Question

Hi team In Prefect Orion how to specific postgres connection url with specific schema instead of using public I am trying to use postgres instead of SQLite

Kevin Kho · Answer

Hi Xavier have you seen <https orion docs prefect io concepts database configuring a postgresql database|this> page

Xavier Babu · Answer

Kevin I did But it doesn t have info about how to specify the schema name in the connection URL

Kevin Kho · Answer

ah i see what you mean

Kevin Kho · Answer

I d need to ask the team on this

Kevin Kho · Answer

We don t design to give our schemas prefect prefixed names to guarantee against collision with other schemas because we don t develop anticipating overlapping databases You could change the default schema for the db user you re using for Orion on the postgres side with `ALTER USER my user WITH DEFAULT SCHEMA = OtherSchema `

Kevin Kho · Answer

Note this is not recommended because it may cause future issues

Xavier Babu · Answer

Alter user works for me But I can t create new user for every environment Choosing different schema is the right way to address this issue

Kevin Kho · Answer

Our recommendation here is for things to be separated by different databases on the same pg server