Error Message: 42704: unrecognized configuration parameter "sql_mode"

When I run the following in my Postgres database, it gives Message
42704: unrecognized configuration parameter "sql_mode".

**SET sql_mode='PIPES_AS_CONCAT';

SELECT 'select MAX(LENGTH('||COLUMN_NAME || ')), ''' ||COLUMN_NAME || ''' FROM test UNION'
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA='test'
AND TABLE_NAME='test';**

Can someone help what is wrong with the query?

0 answers