Re: Help with a plpgsql function - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Help with a plpgsql function
Date
Msg-id 20020221142731.C23226-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Help with a plpgsql function  (Roberto Andrade Fonseca <randrade@abl.com.mx>)
List pgsql-general
>         REVOKE ALL ON my_record.table FROM my_user;

I'd guess you'd need to use EXECUTE here, maybe
EXECUTE ''REVOKE ALL ON '' || my_record.table ||
 '' FROM my_user'';


pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: OID - insert statement
Next
From: GoodleafJ@immunex.com
Date:
Subject: Re: ANY GOOD USER'S GUIDE ONLINE?? (with simple examples)