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
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 |