[PATCH] psql visibility clarification patch
От | D. Hageman |
---|---|
Тема | [PATCH] psql visibility clarification patch |
Дата | |
Msg-id | Pine.LNX.4.50.0301231438260.999-200000@moko.dracken.com обсуждение исходный текст |
Ответы |
Re: [PATCH] psql visibility clarification patch
|
Список | pgsql-hackers |
Attached is a patch that I would like to submit for discussion. The goal of this patch is a solution to the issue that I found concerning table visibility. The problem with the way psql currently lists tables in a database is that it limits it to only the tables currently in the search path. If it isn't visible, then you will never see the table. This can cause problems for a person that is trying to learn a database for the first time or something along those lines unless they are familiar with the pg_catalog. I think a better solution to handling the issue of visibility is shown below. It will list all of the tables of the database and show another column to give indication of the visibility of the table. eecs=> \d List of relations Schema | Name | Type | Visible | Owner ------------+------------------------+----------+---------+-------term_029 | schedule | table | f | dbaterm_029 | schedule_preceptor | table | f | dbaterm_029 | schedule_preceptor_seq | sequence | f | dbaterm_029 | schedule_seq | sequence | f | dbaterm_029 | schedule_student | table |f | dbaterm_029 | schedule_student_seq | sequence | f | dbaterm_032 | schedule | table | t | dbaterm_032 | schedule_preceptor | table | t | dbaterm_032 | schedule_preceptor_seq | sequence| t | dbaterm_032 | schedule_seq | sequence | t | dbaterm_032 | schedule_student | table | t | dbaterm_032 | schedule_student_seq | sequence | t | dba -- //========================================================\\ || D. Hageman <dhageman@dracken.com> || \\========================================================//
В списке pgsql-hackers по дате отправления: