search_path for schemas

From: Ferruccio Zamuner <nonsolosoft(at)diff(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: search_path for schemas
Date: 2003-03-20 09:33:05
Message-ID: 200303200933.h2K9X5W20983@tnt.diff.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martin Foster 2003-03-20 10:18:26 Case sensitivity and migration
Previous Message Thomas T. Thai 2003-03-20 08:53:48 CASE WHEN ERROR: Void value