postgres grant user ability to create tables in schema code example

Example 1: Database owner can't create new tables postgres

GRANT ALL ON schema public TO foo_user;

Example 2: Database owner can't create new tables postgres

REVOKE ALL ON schema public FROM public;