openlibrary-db.sql

-- create the database
\i 'db_scripts/db_openlibrary.sql';

-- switch to using the new database
\c openlibrary;

-- additional extensions
create extension pg_trgm;

-- set client encoding
set client_encoding = 'UTF8';

-- create tables
\i 'db_scripts/tbl_authors.sql';
\i 'db_scripts/tbl_works.sql';
\i 'db_scripts/tbl_author_works.sql';
\i 'db_scripts/tbl_editions.sql';
\i 'db_scripts/tbl_edition_isbns.sql';

-- create filenames that can be accessed in lieu of parameters
\i 'db_scripts/tbl_fileinfo.sql';

-- load in data
\i 'db_scripts/load.sql';

-- finally remove temp table
drop table fileinfo;

-- vaccuum analyze will remove dead tuples and try to regain some space
-- if you have enough room, you can use vacuum full analyze which will gain the most space back, but it requires enough space on your computer to make a complete second copy of the db
-- if you add verbose it will explain what it is trying to do.  (vacuum verbose analyze)
vacuum analyze;