search_path for schemas
От | Ferruccio Zamuner |
---|---|
Тема | search_path for schemas |
Дата | |
Msg-id | 200303200933.h2K9X5W20983@tnt.diff.org обсуждение исходный текст |
Ответы |
Re: search_path for schemas
|
Список | pgsql-general |
Hi, there is something wrong into use of search_path and psql "\d" command. Look: bash-2.05a$ psql try Welcome to psql 7.3.2, the PostgreSQL interactive terminal. [...] try=> create schema first; CREATE SCHEMA try=> create schema second; CREATE SCHEMA try=> create schema third; CREATE SCHEMA try=> create table first.simple ( id int4 primary key, note text); CREATE TABLE try=> create table second.simple ( id int4 primary key, note text); CREATE TABLE try=> create table third.simple ( id int4 primary key, note text); CREATE TABLE try=> SHOW search_path; search_path -------------- $user,public (1 row) try=> SET search_path to 'first','second','third'; SET try=> \d List of relations Schema | Name | Type | Owner --------+--------+-------+------- first | simple | table | fer (1 row) try=> SHOW search_path; search_path ------------------------ first, "second", third (1 row) I think to see following result there instead: List of relations Schema | Name | Type | Owner --------+--------+-------+------- first | simple | table | fer second | simple | table | fer third | simple | table | fer Where I've failed? Thank you in advance, \fer
В списке pgsql-general по дате отправления: