Yep bad scraping from one site to another. Probably encoding.
Thanks for telling me what (should) have been obvious about the two INs. The
gobbledy gook was bad encoding between the two web pages.
select
Dennis Gearon
Signature Warning
EARTH has a Right To Life,
otherwise we
On Tue, 18 May 2010 10:05:49 -0700 (PDT), Dennis Gearon wrote about
[GENERAL] use of IN() with literals:
>I'm trying to use the following script: (to give command line ability
>to change grant on all tables in public in a database)
>
>psql -t -c “SELECT ‘GRANT $1 ON public.’ ||
Dennis Gearon wrote on 18.05.2010 19:05:
select * from pg_class where relkind IN IN (‘r’, ‘v’, ‘S’);
^^ ^ ^
You repeated the keyword IN, and you are using the wrong quotes (unless this is a
copy & paste problem of a broken email client)
select *
fr
I'm trying to use the following script: (to give command line ability to change
grant on all tables in public in a database)
psql -t -c “SELECT ‘GRANT $1 ON public.’ || t.relname || ‘ TO $2;’ from
pg_class t, pg_namespace s WHERE t.relkind IN (‘r’, ‘v’, ‘S’) AND
t.relnamespace=s.oid AND s.nspna
