Skip to content

Instantly share code, notes, and snippets.

@fcarlone
Created February 21, 2018 18:48
Show Gist options
  • Save fcarlone/37ea273900bd84efa28f2be8cd3c3041 to your computer and use it in GitHub Desktop.
Save fcarlone/37ea273900bd84efa28f2be8cd3c3041 to your computer and use it in GitHub Desktop.
Module 5: Software Engineering Principles - Relational Database Fundamentals Checkpoint 2: Installing and Using Relational Databases
// $ psql -f Downloads/library-data.sql library postgres
// $ psql library postgres
// library-# SELECT * FROM books;
RESULT:
id | title | author
------+------------------------------------------+---------------------
1259 | Eloquent Ruby | Russell A. Olson
1593 | JavaScript: The Good Parts | Douglas Crockford
8982 | Designing Object-Oriented Software | Rebecca Wirfs-Brock
7265 | Practical Object-Oriented Design in Ruby | Sandi Metz
(4 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment