Installing and Using Relational Databases

gistfile1.txt

postgres=# \l
                                                 List of databases
   Name    |  Owner   | Encoding |          Collate           |           Ctype            |   Access privileges
-----------+----------+----------+----------------------------+----------------------------+-----------------------
 inventory | postgres | UTF8     | English_United States.1252 | English_United States.1252 |
 library   | postgres | UTF8     | English_United States.1252 | English_United States.1252 |
 postgres  | postgres | UTF8     | English_United States.1252 | English_United States.1252 |
 template0 | postgres | UTF8     | English_United States.1252 | English_United States.1252 | =c/postgres          +
           |          |          |                            |                            | postgres=CTc/postgres
 template1 | postgres | UTF8     | English_United States.1252 | English_United States.1252 | =c/postgres          +
           |          |          |                            |                            | postgres=CTc/postgres
(5 rows)


postgres=# \c library
WARNING: Console code page (437) differs from Windows code page (1252)
         8-bit characters might not work correctly. See psql reference
         page "Notes for Windows users" for details.
You are now connected to database "library" as user "postgres".
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)