Postgres Pro
Downloads
Home   >   mailing lists

Re: Generating GRANT/REVOKE on functions from catalog - Mailing list pgsql-general

From Tom Lane
Subject Re: Generating GRANT/REVOKE on functions from catalog
Date
Msg-id 23623.1249426743@sss.pgh.pa.us
Whole thread Raw
In response to Re: Generating GRANT/REVOKE on functions from catalog  (Doug Gorley <doug.gorley@gmail.com>)
Responses Re: Generating GRANT/REVOKE on functions from catalog  (Doug Gorley <doug.gorley@gmail.com>)
List pgsql-general
Tree view 
Doug Gorley <doug.gorley@gmail.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

pgsql-general by date:

Previous
From: Paul Taylor
Date:
Subject: Re: Does derby have an embedded Mode like Derby ?
Next
From: Eugen Dueck
Date:
Subject: LISTEN ON table WHERE attr1 LIKE '%abc%';