How do I set "options" parameter in a PostgreSQL connection string?

Vote count: 0

Using PG 9.5. Towards the bottom of the libpq-connect documentation page, just before application_name is the options parameter keyword, which I would like to use to set a specific work_mem value.

I'm just not sure how to use this keyword, along with a value. Here is my configuration file:

dbconnection host=localhost dbname=test user=xxx application_name=test options='work_mem=256MB' password=xxx

What is the correct syntax? Incidentally, I don't know how to check for work_mem value of an active socket. That would also help, thanks in advance!

asked 45 secs ago

Jeff

Let's block ads! (Why?)

How do I set "options" parameter in a PostgreSQL connection string?