Select 2 parameters as one concatenated with chars between in postgres

Question

I would like to get row from Postgres database. This row in db have to parameters(column): firstname and lastname.

Regular Select query would download theme as separate fields. but I would like to concatenate them with dot between them.

I would like to get from row:

firstname lastname

one value as follow: firstname.lastname

Currently I do something like this:

SELECT (firstname, lastname) AS user FROM users

But In result I am getting:

(firstname,lastname)

Can You help?

Nuri Tasdemir · Accepted Answer · 2016-03-22 13:15:54Z

1

Use the following

SELECT (firstname::text || '.'::text || lastname::text) AS user FROM users

answered Mar 22, 2016 at 13:15

Nuri Tasdemir

9,8823 gold badges47 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

It worked. Thanks. Can You tell me how to make result lowercase?

lower(firstname::text || '.'::text || lastname::text)