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