On 17 Aug 2010, at 18:28, Chris Barnes wrote: > psql database -t -c "select ||'select count (*) from > '||schemaname||'.'||relname from pg_stat_user_tables where relname like > 'table_%'"|more > ERROR: operator does not exist: || unknown > LINE 1: select ||'select count (*) from '||schemaname||'.'||relname .... > ^ > HINT: No operator matches the given name and argument type(s). > You might need to add explicit type casts
There's nothing before the first concat operator ;) Alban Hertroys -- Screwing up is an excellent way to attach something to the ceiling. !DSPAM:737,4c6ac41b967634613617124! -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
