Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Exercise:
- Create a database called library using the appropriate Postgres command line tools.
- Download and execute this file in the database: Library Data
- Run the following query using psql to confirm that the data was imported correctly.
- Create a gist with the results and submit the answers.
- Output:
- library=# SELECT * FROM books;
- 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)
Add Comment
Please, Sign In to add comment