Differences

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

--- labs:postgresql [2009/07/06 20:58] – admin
+++ labs:postgresql [2017/07/25 16:22] (current) – [Update Statements] admin
@@ Line 13: / Line 13: @@
 You can use * to mean all columns in the table.  Likely, you will want to specify only the columns you want to appear in your results.
+=== 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}}
 ==== Insert Statements ====
@@ Line 44: / 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 53: / 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";
-==== 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 85: / Line 108: @@
   SELECT * FROM pg_roles;
+==== Creating User ====
+  CREATE USER username [WITH PASSWORD ''] ;
+Or
+  createuser
+==== Adding user to groups ====
+  ALTER GROUP groupname ADD user username [, ... ]
 ==== Granting Permissions ====
@@ Line 105: / Line 139: @@
   ALTER TABLE table_name ADD COLUMN col_name type ...
+=== Change Column ===
+  ALTER TABLE quizzes ALTER COLUMN name TYPE varchar(30);
 ==== Dump Data Base ====
   pg_dump <dbname>
+==== Connecting to Another Database (''use'' in MySQL) ====
+  \c dbname