aggregate all columns

In other SQL tools (ex postgres) exists composite type.

In a useful way it's possible to concat quickly all the column of a table in a single string

SELECT (c.*)::text FROM mytable c

It's useful where ignore the content of columns to have the ability to regex all the field at the same time in a simple request, example :

SELECT * FROM mytable c WHERE (c.*)::text LIKE '%mysearch%' LIMIT 3;