On Sun, Aug 17, 2003 at 02:04:03PM -0600, Scott Lamb wrote:
> Martijn van Oosterhout wrote:
> >grant select on ":2" to ":1"
> >\for select usename, relname from pg_catalog.pg_user, pg_catalog.pg_class
> >where relname not like 'pg_%';
>
> That's definitely a useful thing to do, but I'm not sure I like your
> syntax. As someone else mentioned, the ":2" is confusing; it's like a
> bind variable, but isn't. And real bind variables don't work, as you are
> substituting identifiers, not literals.
>
> You're not completely out in the cold doing something like this without
> a patch. Right now, I believe you can do something like (in Oracle
> PL/SQL-ish syntax; it's more familiar to me):
Hmm, I didn't know you could execute pl/sql from the prompt like that.
Still, I was looking for something that was short and easy to type. Not to
mention something I can remember :)
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> "All that is needed for the forces of evil to triumph is for enough good
> men to do nothing." - Edmond Burke
> "The penalty good people pay for not being interested in politics is to be
> governed by people worse than themselves." - Plato