How can I set the schema?

[jashworth]

Is there a way to set the schema so that I don't have to prefix table names with it in every query?

I've tried including it in the call to createPool as a parameter to the connection url:
postgres://...?schema=myschema
postgres://...?currentSchema=myschema
but that doesn't seem to work.

thanks

[gajus]

Does https://www.npmjs.com/package/pg support this?

[jashworth]

I got it working by setting the PG_OPTIONS environment variable.

PG_OPTIONS="-c search_path=my_schema"

thanks

[mull]

If anyone else arrives here scratching their head for a while, the trick is that it's PGOPTIONS, not PG_OPTIONS :)