How to concatenate strings in PostgreSQL?

Member

by orpha , in category: PHP Databases , 8 months ago

How to concatenate strings in PostgreSQL?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

by jasen_gottlieb , 4 months ago

@orpha In PostgreSQL, you can concatenate strings using the CONCAT function. The syntax is CONCAT(string1, string2, ...). For example,

1
SELECT CONCAT('Hello', ' ', 'World');

This query will return the concatenated string "Hello World".