Postgresql: INSERT INTO using SELECT and values

Question

Postgresql version: 9.1.9

I'm trying to insert data into a table using SELECT and passing values

Example of what i try to accomplish:

current database:

MyTable
character    number
'a'            '0'
'b'            '1'
'c'            '1'

what i want:

MyTable
character    number
'a'            '0'
'b'            '1'
'c'            '1'
'b'            '2'
'c'            '2'

I tried different things but i can't seem to get it right. For example:

INSERT INTO MyTable (character, number)
    (SELECT character FROM MyTable WHERE number = '1', '2')

Note: The numbers are actually long strings and therefore have to be in brackets.

Thanks.

tkruse · Accepted Answer · 2018-01-11 03:22:29Z

23

INSERT INTO MyTable (character, number) 
    SELECT character, '2' FROM MyTable WHERE number = '1'

to save the data in the same format on your example

tkruse

10.7k7 gold badges58 silver badges89 bronze badges

answered Nov 5, 2013 at 22:17

pobrelkey

6,00123 silver badges29 bronze badges

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

1 Answer 1