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|
I have a (stupid) question regarding using concatenation operator.
I would like to get the list of tables from the database and output the select
count(*) for each of them
I don't want the schema name proceeding the select, how can I omit without
receiving the error below.
psql eventdb0
