/SQL/Postgres update single column

Postgres update single column

Postgres update column with value from another table

UPDATE t1 
set "Column" = t2.column
from t2 
where t2.id = t1."Id";

3

Postgres update single column

UPDATE table_name 
SET column_one = TRUE,
WHERE column_two = 'some string'

1

Similar codes

2 votes415 views1 answer
Install postgresql centos 5
SQL
1 vote362 views1 answer
Oracle previous year
SQL
6 votes352 views2 answers
Postgresql restore from dump
SQL
0 vote334 views1 answer
Porcentaje sql
SQL
4 votes344 views1 answer
Oracle table statistics last analyzed
SQL
0 vote368 views1 answer
Psotgres multiple values
SQL
0 vote364 views1 answer
Alter domain sql
SQL
0 vote365 views1 answer
Shortcut run sql pgadmin
SQL
2 votes353 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
0 vote359 views1 answer
Import sql in postgresql
SQL

Share