Re: GRANT ON ALL IN schema

decibel wrote:
> In this specific case, I think there's enough demand to warrant a 
> built-in mechanism for granting, but if something like exec() is 
> built-in then the bar isn't as high for what the built-in GRANT 
> mechanism needs to handle.
> 
> CREATE OR REPLACE FUNCTION tools.exec(
>     sql text
>     , echo boolean
> ) RETURNS text LANGUAGE plpgsql AS $exec$

Perhaps another two functions too:

list_all(objtype, schema_pattern, name_pattern)
exec_for(objtype, schema_pattern, name_pattern, sql_with_markers)

Obviously the third is a simple wrapper around the first two.

--   Richard Huxton  Archonet Ltd