How to set schema?

[kesavkolla]

I don't see any connection parameter for search_path. This is very useful specially when we have to deal with multiple schemas inside Postgres.

[chandr-andr]

Could you please share a example of usage?

[kesavkolla]

I found the solution what I was looking for.

Basically options is what I need to set.

options('-csearch_path=schema1,public,pg_catalog')

Once I set this one I could make my queries to work properly.

[chandr-andr]

Great, thanks!