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.’ || 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.nspname=’public’;” $3 | psql $3 > >and it always fails at the "IN(‘r’, ‘v’, ‘S’)" part. psql won't accept >the literals in the IN clause. Is this normal? What could fix this? It works for me, using 8.4.2. >I've tried just doing: >( >after logging in to psql connected to a specific database) > >select * from pg_class where relkind IN IN (‘r’, ‘v’, ‘S’); You have the word "IN" twice. -- Regards, Dave [RLU #314465] ====================================================================== dwn...@ntlworld.com (David W Noon) ======================================================================
signature.asc
Description: PGP signature
