PQconnectdb set search_path (schema) while connecting

Question

How do I specify the search_path while connecting to my postgres db using PQconnectdb? I want to set the search_path to my_schema. I'm currently using the following connection command:

PQconnectdb("host=localhost user=my_user password=my_password port=5432 dbname=my_db")

m7913d · Accepted Answer · 2021-02-20 01:34:57Z

4

You could add the following to your connection info:

options='-csearch_path=my_schema'

So, it would become:

PQconnectdb("host=localhost user=my_user password=my_password port=5432 dbname=my_db options='-csearch_path=my_schema'")

Reference:

https://www.postgresql.org/message-id/D960CB61B694CF459DCFB4B0128514C20886AD46@exadv11.host.magwien.gv.at

answered Feb 20, 2021 at 1:34

m7913d

11.1k7 gold badges33 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PQconnectdb set search_path (schema) while connecting

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related