search_path for schemas

Поиск
Список
Период
Сортировка
От Ferruccio Zamuner
Тема search_path for schemas
Дата
Msg-id 200303200933.h2K9X5W20983@tnt.diff.org
обсуждение исходный текст
Ответы Re: search_path for schemas  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Joel Rodrigues
Дата:
Сообщение: PostgreSQL downloads compressed with bzip2 instead of gzip ?
Следующее
От: Stéphane Pinel
Дата:
Сообщение: Handling Blobs with libpq