Is it possible to set postgres search_path in node-postgres?

Question

I'm moving an application from RoR to Express.js. ActiveRecord postgres adapter has the search_path configuration option.

Is it possible to set the search_path for the Client ?

[There is a number of ways to set the `search_path`.](http://stackoverflow.com/a/9067777/939860)' — Erwin Brandstetter, Apr 06 '13 at 11:48

score 2 · Answer 1 · answered May 15 '13 at 00:57

My preference would be to chance this on the database or user if possible.

ALTER [DATABASE or USER] [name] set search_path='[searchpath]'

If that fails you can always make sure your search path is set by building into your connection logic:

SET search_path='[searchpath]'

That will set it on the connection.

score 1 · Answer 2 · answered Nov 20 '21 at 16:43

1

Yes sure you can automaticaly triger SET command "on" connection event

pool.on('connect', (client) => {
  client.query('SET search_path TO schema,public');
});

answered Nov 20 '21 at 16:43

Tim Kozak

score 0 · Answer 3 · answered Oct 10 '22 at 23:01

0

process.env.PGOPTIONS="-c search_path=some_schema"

answered Oct 10 '22 at 23:01

unused-user

3

Your answer could be improved by adding more information on what the code does and how it helps the OP. – Tyler2P Oct 11 '22 at 17:12

3 Answers3