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