Re: Generating GRANT/REVOKE on functions from catalog

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Doug Gorley <doug(dot)gorley(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Generating GRANT/REVOKE on functions from catalog
Date: 2009-08-04 22:59:03
Message-ID: 23623.1249426743@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Doug Gorley <doug(dot)gorley(at)gmail(dot)com> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Eugen Dueck 2009-08-04 23:36:43 LISTEN ON table WHERE attr1 LIKE '%abc%';
Previous Message Doug Gorley 2009-08-04 22:45:02 Re: Generating GRANT/REVOKE on functions from catalog