How access to other column the same row in the table

Queries and Resources
1

I've a table using query to Postgres, but my question is how I can access from a column to value in the other column for the same row.

Example:
SELECT phoneCode, phoneNumber FROM clients

On my table I want use only one column that contain the values phoneCode concat phoneNumber

Help me please :slight_smile:

2

Hi @zeroray, you can use the double pipe (||) for concatenating those two as long as one of the columns is string.