Yugo NAGATA <nag...@sraoss.co.jp> writes: > We can specify more than one privilege type in > "ALTER DEFAULT PRIVILEGES GRANT/REVOKE ON SCHEMAS", > for example,
> ALTER DEFAULT PRIVILEGES GRANT USAGE,CREATE ON SCHEMAS TO PUBLIC; > However, the syntax described in the documentation looks to > be allowing only one, > GRANT { USAGE | CREATE | ALL [ PRIVILEGES ] } > ON SCHEMAS > TO { [ GROUP ] role_name | PUBLIC } [, ...] [ WITH GRANT OPTION ] > while the syntaxes for tables and sequences are described correctly. Yup, you're right. I'll push this shortly. regards, tom lane