Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| labs:postgresql [2013/06/21 19:38] – [Select Statements] 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 60: | Line 63: | ||
| ===== Creating Tables ===== | ===== Creating Tables ===== | ||
| - | ==== Creating Sequences ==== | + | |
| + | Example: | ||
| + | |||
| + | CREATE TABLE table_name ( | ||
| + | id integer NOT NULL default nextval(' | ||
| + | eagle_id char(9), | ||
| + | floor_to_graffito_height varchar(30), | ||
| + | description text, | ||
| + | comment text, | ||
| + | translation text, | ||
| + | FOREIGN KEY ( eagle_id ) REFERENCES EAGLE_inscriptions(id), | ||
| + | PRIMARY KEY (id) | ||
| + | ); | ||
| + | ===== Creating Sequences | ||
| | | ||
| - | ==== Viewing Table Information ==== | + | ===== Viewing Table Information |
| You may want to look at a table' | You may want to look at a table' | ||
| Line 100: | Line 116: | ||
| createuser | createuser | ||
| + | ==== Adding user to groups ==== | ||
| + | |||
| + | ALTER GROUP groupname ADD user username [, ... ] | ||
| ==== Granting Permissions ==== | ==== Granting Permissions ==== | ||
