Maybe I'm missing something, but doesn't this solve your problem as stated?
ALTER DEFAULT PRIVILEGES IN SCHEMA myschema GRANT SELECT ON TABLES TO public; regards, tom lane
Maybe I'm missing something, but doesn't this solve your problem as stated?
ALTER DEFAULT PRIVILEGES IN SCHEMA myschema GRANT SELECT ON TABLES TO public; regards, tom lane