SHARE
TWEET

Untitled

a guest Jan 22nd, 2019 51 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Exercise:
  2.  
  3. Create a database called library using the appropriate Postgres command line tools.
  4. Download and execute this file in the database: Library Data
  5. Run the following query using psql to confirm that the data was imported correctly.
  6. Create a gist with the results and submit the answers.
  7.  
  8. Output:
  9.  
  10. library=# SELECT * FROM books;
  11.   id  |                  title                   |       author
  12. ------+------------------------------------------+---------------------
  13.  1259 | Eloquent Ruby                            | Russell A. Olson
  14.  1593 | JavaScript: The Good Parts               | Douglas Crockford
  15.  8982 | Designing Object-Oriented Software       | Rebecca Wirfs-Brock
  16.  7265 | Practical Object-Oriented Design in Ruby | Sandi Metz
  17. (4 rows)
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top