Differences

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

--- labs:postgresql [2013/06/21 19:37] – [Select Statements] admin
+++ labs:postgresql [2016/06/27 16:09] – [Creating Tables] admin
@@ Line 15: / Line 15: @@
 === Explanation of Various Joins ===
+The picture below comes from [[http://stackoverflow.com/questions/38549/difference-between-inner-and-outer-join|here]].
 {{http://i.stack.imgur.com/1UKp7.png}}
@@ Line 58: / Line 60: @@
 ===== 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";
-==== Viewing Table Information ====
+===== Viewing Table Information =====
 You may want to look at a table's attributes and their types.  In a PostgreSQL client, you can use the command ''\d tablename'', e.g.,
@@ Line 98: / Line 113: @@
   createuser
+==== Adding user to groups ====
+  ALTER GROUP groupname ADD user username [, ... ]
 ==== Granting Permissions ====