psql concat string code example

Example 1: postgres concat

update "ExportTables" SET "Name" = CONCAT("Name", '.csv')

Example 2: postgress append string in select

SELECT
   'Concatenation' || ' ' || 'Operator' AS result_string;