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
