jessicard · October 3, 2012 19:12
diff --git a/create db b/create db
 CREATE DATABASE contacts;
diff --git a/create table b/create table
 \connect contacts
 CREATE TABLE friends(firstname TEXT, lastname TEXT phone TEXT);
diff --git a/delete db b/delete db
 DROP DATABASE contacts;
diff --git a/delete friend b/delete friend
 DELETE FROM friends WHERE firstname = 'david';
diff --git a/insert friend b/insert friend
 INSERT INTO friends(firstname, lastname, phone) VALUES ('david', 'aragon', '1234567890');
diff --git a/quit b/quit
 \q
diff --git a/select all b/select all
 SELECT * FROM friends;
diff --git a/show dbs b/show dbs
 \l
diff --git a/start b/start
 psql -h localhost
	\connect contacts
	CREATE TABLE friends(firstname TEXT, lastname TEXT phone TEXT);