search_path and current_schema
От | Jayadevan M |
---|---|
Тема | search_path and current_schema |
Дата | |
Msg-id | CAFS1N4jbpZnuywZaxZs0mbtYp1hqCoZag2LLH4Xz=JDCc1NjWA@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: search_path and current_schema
|
Список | pgsql-general |
Hi,
I was trying out schema settings and related functions. PostgreSQL version is 9.3
[postgres@MyCentOS 9.3]$ psql
psql (9.3.0)
Type "help" for help.
postgres=# show search_path;
search_path
----------------
"$user",public
(1 row)
postgres=# select current_schemas(true);
current_schemas
---------------------
{pg_catalog,public}
(1 row)
postgres=# set search_path=mynewschema, "$user", public;
SET
postgres=# select current_schemas(true);
current_schemas
---------------------
{pg_catalog,public}
(1 row)
postgres=# show search_path;
search_path
------------------------------
mynewschema, "$user", public
(1 row)
В списке pgsql-general по дате отправления: