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 по дате отправления: