PostgreSQL, add prefix to record field in SQL

Question

the problem is: is there a query in postgreSQL that will add some prefix to every record specific field? For example let's assume we have table users:

**id**    **name**
  1        adam
  2        ewa

and i want to get records and add to every id some specific prefix - let's say 'foo_', desirable result:

id: 'foo_1', name: adam
id: 'foo_2', name: ewa

I know it can be done with Python after retrieving records, but i wonder if possible with query.

Thanks in advance!!

sqlfiddle.com/#!15/efa43/2

Konstantin V. Salikhov
– Konstantin V. Salikhov

2015-05-27 08:01:56 +00:00
Commented May 27, 2015 at 8:01 — Konstantin V. Salikhov
– Konstantin V. Salikhov, Commented May 27, 2015 at 8:01

user330315 · Accepted Answer · 2015-05-27 08:01:12Z

2

select 'foo_'||id::text,
       name
from the_table;

answered May 27, 2015 at 8:01

user330315

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

Comments

Nandakumar V · Accepted Answer · 2015-05-27 08:02:38Z

2

You can just use a concatenation operator String Functions and Operators

SELECT 'foo_' || id::text FROM table

answered May 27, 2015 at 8:02

Nandakumar V

4,7255 gold badges33 silver badges50 bronze badges

Collectives™ on Stack Overflow

PostgreSQL, add prefix to record field in SQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related