want to quickly check the permissions on your #postgreql DB? simply run these 5 easy to remember commands:
\du
\l+ (db name)
\dn+
\dp
\ddp
(and then cross reference the list of 9 characters next to each username against the manual)
(about sums up my confusion this evening)