PostgreSQL insert select multiple column values

Question

I have a table with three columns:

Name Surname NameSuname
Bob  Marley  NULL
John Doe     NULL

I want to insert values from Name and Surname columns into NameSuname column. How can I do that?

Calipso · Accepted Answer · 2014-07-24 19:12:59Z

2

You need to update the coumn instead of inserting

UPDATE MyTable
  SET NameSuname = Name || ' ' || Surname

edited Jul 24, 2014 at 19:12

user330315

answered Jul 24, 2014 at 19:12

Calipso

9673 gold badges15 silver badges33 bronze badges

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

1 Comment

StAlphonzo Over a year ago

Of course, you combine the 2 by using a trigger that fires after table insert, which will do the update for you, getting you back to the impression that you're only doing an insert. Plus it will be part of the same transaction, thus all fail or all succeed.

Collectives™ on Stack Overflow

PostgreSQL insert select multiple column values

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related