Perfect, I'm using the following function:
create or replace function fn_sig(p_oid oid) returns text
as $$
begin
return p_oid::regprocedure;
end;
$$ language plpgsql;
In the following query:
select
pg_namespace.nspname ||
'.' ||
fn_sig(pg_proc.oid)
from
pg_proc
inner join pg_namespace
on pg_proc.pronamespace = pg_namespace.oid
Thanks very much!
------------------------------------------------------------------------
*Doug Gorley* | doug.gorley@xxxxxxxxx <mailto:doug.gorley@xxxxxxxxx>
Tom Lane wrote:
Doug Gorley <doug.gorley@xxxxxxxxx> writes:
That looks like exactly what I want. Is there an easy way to cast that
to a string so that I can concatenate it into a GRANT statement?
Well, since 8.3 you just cast it to a string ;-)
In older versions I'd suggest a plpgsql wrapper function. plpgsql has
always been very lax about letting you assign anything to anything,
so you can cast by assignment.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
