Differences

This shows you the differences between two versions of the page.

--- labs:postgresql [2016/06/27 16:06] – [Viewing Table Information] 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 =====
@@ Line 60: / Line 63: @@
 ===== Creating Tables =====
-==== Creating Sequences ====
+Example:
+  CREATE TABLE table_name (
+	id integer NOT NULL default nextval('inscription_id_seq'),
+	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 =====
    create sequence "majors_id_seq";