By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE ROLE
CREATE TABLE
CREATE VIEW
GRANT
SELECT 0
GRANT
| grantor | grantee | table_catalog | table_schema | table_name | column_name | privilege_type | is_grantable |
|---|---|---|---|---|---|---|---|
| postgres | alice | postgres | public | recent_sales_v | description | SELECT | NO |
| postgres | alice | postgres | public | recent_sales_v | id | SELECT | NO |
SELECT 2