I just noticed that you can't make normal tables in public: https://dbfiddle.uk/?rdbms=postgres_15&fiddle=06580f43fb20dcc9469a77111c9a077f
This is related to https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=b073c3ccd06e4cb845e121387a43faa8c68a7b62
Of course I can make my own schema, and make tables in it, but perhaps it would be possible to make the fiddle user owner of the db? or explicitly grant them the privileges to create objects in public?
I've made the fiddle user owner of the public schema so this works now.
Thanks for pointing this out, I read [your post](https://www.depesz.com/2021/09/10/waiting-for-postgresql-15-revoke-public-create-from-public-schema-now-owned-by-pg_database_owner/) about it last year but forgot it. A very sensible change in my opinion.