Re: Namespace/Table Visibility Behavior Issues - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Namespace/Table Visibility Behavior Issues
Date
Msg-id 24900.1042959347@sss.pgh.pa.us
Whole thread Raw
In response to Namespace/Table Visibility Behavior Issues  ("D. Hageman" <dhageman@dracken.com>)
List pgsql-hackers
"D. Hageman" <dhageman@dracken.com> writes:
> I am not sure that is wise to do the pg_table_is_visible check on those 
> commands.  In my humble opinion, those commands are for understanding the 
> layout/structure/nature of the database.  If you can't see all your 
> namespaces that you set in your search_path then it could distort ones 
> understanding of the database.  

What would you have it do --- list tables that you cannot actually
access without qualification?  That doesn't seem like an improvement to
me.

You could write "\d *.*" to see everything, or "\d test_1.*" and
"\d test_2.*" to see the full contents of those two schemas.  But
ISTM that \d without any schema qualification should only show tables
that you can access without any schema qualification.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Lamar Owen
Date:
Subject: Re: Heading to Atlanta
Next
From: mlw
Date:
Subject: Re: Can we revisit the thought of PostgreSQL 7.2.4?