Search Postgresql Archives

information_schema.columns.column_default filtered based on user

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux