设置默认的search path(schema)

From PostgreSQL 中文维基, PostgreSQL 中文站, PostgreSQL 中国社区, PostgreSQL Chinese community

Jump to: navigation, search

把用户jianingy的默认search_path设置为schema和public

   ALTER USER jianingy SET search_path to schema, public

酱紫不用每次通过psql登录的时候输入set search_path to了.

Personal tools