The search_path parameter specified when connecting does not work

Support
1

I created the schema in advance and connected to neon with the search_path parameter
But all subsequent queries were against the public schema.

I tried connecting with psql, but got an error invalid URI query parameter.

# pql postgres://<user_name>:<password>@ep-rough-salad-99491047.us-east-2.aws.neon.tech/sampledb?search_path=sample_schema
psql: error: invalid URI query parameter: "search_path"

The same specification works for postgres running locally. How do I specify schema in neon?

1 Like
2

I was able to resolve the issue myself by re-reading the documentation of postgresql.

The parameters were incorrectly specified:

options=--search_path%3Dsample_schema and it worked as expected.

Thanks.

1 Like