How to save results of query into a new column, postgres

Question

How to add results of selecting query to a new column in already existing table in PostgreSQL in pgAdmin?

Results of the select query is an alteration of over columns in the same table.

Please Edit your question and add some sample data and the expected output based on that data. Formatted text please, no screen shots — user330315
– user330315, Commented Jan 13, 2017 at 12:35
try something like this with new_table as ( SELECT id, col1-col2 as diff from yourtable ) update yourtable as yt set time_diff = yt.diff from new_table yt where yt.id = tr.id; — Chandan Rai
– Chandan Rai, Commented Jan 13, 2017 at 12:35

Fabian Pijcke · Accepted Answer · 2017-01-13 13:20:48Z

1

Just create the column and update data afterwards (using the command line bundled in pgadmin):

ALTER TABLE tablename ADD COLUMN colname coltype;
UPDATE tablename SET colname = yourexpression;

answered Jan 13, 2017 at 13:20

Fabian Pijcke

3,31027 silver badges30 bronze badges

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

1 Comment

thanks, had the same thing, just had a problem with column name