postgresql_up_and_running_3e_code_data

OReilly/postgresql_up_and_running_3e_code_data

Fork 0

Go to file

Regina Obe 769a053ce5 Change readme to md format

2026-01-02 10:38:23 -05:00

ch03

first and final commit

2026-01-02 10:36:21 -05:00

ch04

first and final commit

2026-01-02 10:36:21 -05:00

ch05

first and final commit

2026-01-02 10:36:21 -05:00

ch06

first and final commit

2026-01-02 10:36:21 -05:00

ch10

first and final commit

2026-01-02 10:36:21 -05:00

buidling_census_tables.sql

first and final commit

2026-01-02 10:36:21 -05:00

film.sql

first and final commit

2026-01-02 10:36:21 -05:00

game_throws.sql

first and final commit

2026-01-02 10:36:21 -05:00

postgresql_book.sql

first and final commit

2026-01-02 10:36:21 -05:00

README.md

Change readme to md format

2026-01-02 10:38:23 -05:00

test_scores.sql

first and final commit

2026-01-02 10:36:21 -05:00

README.md

The .sql is a plain text SQL backup that should be restored with psql.

It consists of the census and staging schemas. As well as some other minor tables Some of these are built as part of exercises in the book.

To restore:

CREATE DATABASE postgresql_book;
\connect postgresql_book
\i postgresql_book.sql

IMDB movies list comes from ftp://ftp.fu-berlin.de/pub/misc/movies/database/movies.list.gz refer to copyright details in http://www.imdb.com/interfaces Information courtesy of IMDb (http://www.imdb.com). Used with permission.