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 ?

Chris Travers · Accepted Answer · 2013-05-15 00:57:50Z

2

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.

answered May 15, 2013 at 0:57

Chris Travers

26.6k6 gold badges70 silver badges191 bronze badges

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

Comments

Tim Kozak · Accepted Answer · 2021-11-20 16:43:45Z

2

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, 2021 at 16:43

Tim Kozak

4,22244 silver badges44 bronze badges

unused-user · Accepted Answer · 2022-10-10 23:01:02Z

0

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

answered Oct 10, 2022 at 23:01

unused-user

1

Your answer could be improved by adding more information on what the code does and how it helps the OP.