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
relnamelike '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!
