| 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: | Whole Thread | Raw Message | 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 |