How can we point the prefect database to a particular schema inside a db , when i run database upgrade command it always go to public schema, when i try to set schema in

prefect config set PREFECT_API_DATABASE_CONNECTION_URL="<postgresql+asyncpg://prefect_user>:your_secure_password@<your_postgres_host>:5432/my_existing_db"

it always throw error Can any one help here

We have looked at something similar. You could do this with unique users, and each user defaults to a different db/schema rather than trying to use a common user and pointing to specific schema/dbs