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 ?

You can always send SET search_path = '...' commands. – Craig Ringer Apr 6 '13 at 5:42 — Craig Ringer, Apr 6 '13 at 5:42
There is a number of ways to set the search_path.' – Erwin Brandstetter Apr 6 '13 at 11:48 — Erwin Brandstetter, Apr 6 '13 at 11:48

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

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.

1 Answer 1