psql : \dn+ to show default schema privileges

2025-05-21 Thread 노명석
Hello PostgreSQL Hackers, I propose an enhancement to psql \dn+ to display default schema privileges when nspacl is NULL, by using COALESCE with pg_catalog.acldefault('n', n.nspowner). Currently, \dn+ shows NULL for "Access privileges" if a schema's ACLs haven't been explicitly altered. This ca

RE: Re: psql : \dn+ to show default schema privileges

2025-05-21 Thread 노명석
mail about schema owner privileges not being included in the output of pg_dump – do you think it would be better to send a separate email to suggest adding an explanation for this to the documentation?   Yours, Myeongseok Noh   ---원본 메세지------- 보낸사람: "L

RE: Re: Re: psql : \dn+ to show default schema privileges

2025-05-23 Thread 노명석
, I believe the display method for schema privileges in \dn+ should be changed or improved to provide better clarity between these different states.   ---원본 메세지--- 보낸사람: "Laurenz Albe" 받는사람: "노명석" , pgsql-hackers@lists.postgresql.org