Insert value into a column in PostgreSQL

Question

I am trying to figure out how to insert the same value into the entire column of a table? The table already exists and I have an empty column into which I would like to insert a certain value, for example, today's date. I have only found sources explaining how to insert values into an entire row.

dweeves · Accepted Answer · 2018-11-06 15:50:35Z

14

UPDATE myTable SET myColumn='newValue'

newValue can also be an expression.

see http://www.postgresql.org/docs/current/static/sql-update.html

edited Nov 6, 2018 at 15:50

user330315

answered Jul 8, 2010 at 15:54

dweeves

5,64524 silver badges28 bronze badges

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

Comments

rfusca · Accepted Answer · 2010-07-08 15:53:25Z

7

I think we need a bit more info to understand the issue, it sounds like you just want...

INSERT INTO table_foo (my_empty_column_name) values (current_date);

If you've already got data there and you want to UPDATE that column for all rows then...

UPDATE table_foo SET my_empty_column_name = current_date;

answered Jul 8, 2010 at 15:53

rfusca

7,7752 gold badges32 silver badges34 bronze badges

Comments

Fosco · Accepted Answer · 2010-07-08 15:54:40Z

4

I would think you're trying to UPDATE.

UPDATE myTable set myColumn = 'WHATEVER'

answered Jul 8, 2010 at 15:54

Fosco

38.6k7 gold badges90 silver badges101 bronze badges

Collectives™ on Stack Overflow

Insert value into a column in PostgreSQL

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related