Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| labs:postgresql [2016/06/27 16:09] – [Creating Tables] admin | labs:postgresql [2017/07/25 16:22] (current) – [Update Statements] admin | ||
|---|---|---|---|
| Line 51: | Line 51: | ||
| + | To update a table with a value in another table: | ||
| + | | ||
| + | update table2 set t2field = t1.field from table1 t1 where table2.keyfield2 = t1.keyfield1; | ||
| ===== Creating Database ===== | ===== Creating Database ===== | ||
| Line 64: | Line 67: | ||
| CREATE TABLE table_name ( | CREATE TABLE table_name ( | ||
| - | | + | id integer NOT NULL default nextval(' |
| eagle_id char(9), | eagle_id char(9), | ||
| floor_to_graffito_height varchar(30), | floor_to_graffito_height varchar(30), | ||
