Re: How to display default privileges?

On 09/05/2016 03:17 PM, Marc Richter wrote:
> Hi everyone,
>
> from what I know, since PostgreSQL 9.0 it is supported to change default
> privileges for newly created tables, functions and sequences by using
> "ALTER DEFAULT PRIVILEGES".
>
> How to display the current settings?

You can use psql's \ddp, or look in pg_default_acl directly.
--
Vik Fearing                                          +33 6 46 75 15 36
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support