admin管理员组文章数量:1335759
I was searching the documentation of pg-promise specifically in the creation of the client. But I wasn't able to find the option to set the default schema to be used in the connection, it always uses public
schema. How do I set it?
I was searching the documentation of pg-promise specifically in the creation of the client. But I wasn't able to find the option to set the default schema to be used in the connection, it always uses public
schema. How do I set it?
-
1
Default schema is controlled by the server, not by the client, i.e. the library doesn't use
public
by default, it uses whatever is set as the default on the server. – vitaly-t Commented Jan 18, 2017 at 23:13 - Also see this: stackoverflow./questions/2875610/… – vitaly-t Commented Jan 18, 2017 at 23:20
- 2 You can set the schema search path at the user level: see answer http://stackoverflow./questions/2951875/postgresql-how-do-i-set-the-search-path-at-the-user-level – Tim Child Commented Jan 18, 2017 at 23:27
- Ah that's why it's not in the connection parameters. Ok thank you. The link you sent me was really helpful also.So my solution was to set the schema on server start using the SET search_path query. – Emmanuel Campos Commented Jan 18, 2017 at 23:28
- Alternatively, you can have the library inject the schema name automatically. See pg-promise-demo. – vitaly-t Commented Jan 18, 2017 at 23:32
1 Answer
Reset to default 8Normally, one sets the default schema(s) for the database or the role, as explained here:
- Permanently Set Postgresql Schema Path
It is only if you want to do so without persisting the change, you might want to set the schema(s) dynamically, just for the current process.
The library supports option schema
within Initialization Options:
const initOptions = {
schema: 'my_schema' /* can also be an array of strings or a callback */
};
const pgp = require('pg-promise')(initOptions);
making it easier to set the dynamic schema(s).
Examples
Making your own schema visible along with the default
public
schema:const initOptions = { schema: ['public', 'my_schema'] /* make both schemas visible */ }; const pgp = require('pg-promise')(initOptions);
Using the callback to set schema based on the Database Context (see Database constructor):
const initOptions = { schema(dc) { if(dc === /* whatever Database Context was used */) { return 'my_schema'; /* or an array of strings */ } /* other provisions, if multiple databases are used. */ /* can return null/undefined, if no schema change is needed. */ } }; const pgp = require('pg-promise')(initOptions);
本文标签: javascriptHow to set schema in pgpromiseStack Overflow
版权声明:本文标题:javascript - How to set schema in pg-promise - Stack Overflow 内容由网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:http://www.betaflare.com/web/1742290979a2447789.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论