Differences

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

--- labs:postgresql [2016/06/27 16:06] – [Creating Sequences] admin
+++ labs:postgresql [2016/06/27 16:09] – [Creating Tables] admin
@@ Line 60: / Line 60: @@
 ===== Creating Tables =====
+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";