information_schema.columns.column_default filtered based on user

Поиск
Список
Период
Сортировка
От George Pavlov
Тема information_schema.columns.column_default filtered based on user
Дата
Msg-id CCB89282FCE1024EA3DCE687A96A516404CD87CD@ehost010-6.exch010.intermedia.net
обсуждение исходный текст
Ответы Re: information_schema.columns.column_default filtered based on user  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Looking at the information_schema.columns view I have been wondering why
it only shows the column_default for columns in tables owned by the
current user? Makes things a bit misleading. I am thinking at least
superusers should be able to see that?

This is what I am talking about:

CREATE OR REPLACE VIEW information_schema.columns AS
 SELECT current_database()::information_schema.sql_identifier AS
table_catalog,
<snip>
        CASE
            WHEN u.usename = "current_user"() THEN ad.adsrc
            ELSE NULL::text
        END::information_schema.character_data AS column_default,
<snip>

George

В списке pgsql-general по дате отправления:

Предыдущее
От: Claire McLister
Дата:
Сообщение: Re: Error with temporary tables
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Error with temporary tables