Specific schema using connection string

[nvcnvn]

Can I connect to a specific schema using only connection string?

For example a connection string with specific schema:

jdbc:postgresql://localhost:5432/mydatabase?currentSchema=myschema

I guess another option is using connection hooks and set default search path.

[jackc]

You can set the search path in the connection string. e.g. postgresql://example.com/mydatabase?search_path=myschema

[nvcnvn]

Ah thanks you, I should check Test for example first:

pgx/pgxpool/pool_test.go

Line 84 in 3ab8941

connString := "postgres://jack:secret@localhost:5432/mydb?application_name=pgxtest&search_path=myschema&connect_timeout=5"

for one who have the same question.