- Connect to psql in terminal
psql postgres
- Run
CREATE DATABASE bookmark_manager;
- Run
psql \c bookmark_manager;
(to connect to new db) - Create
bookmarks
table using the query saved in the file01_create_bookmarks_table.sql
- Connect to psql in terminal
psql postgres
- Run
CREATE DATABASE bookmark_manager_test;
- Run
psql \c bookmark_manager_test;
(to connect to new db) - Create
bookmarks
table using the query saved in the file01_create_bookmarks_table.sql
- Connect to postgres in terminal
psql postgres
- Run
psql \c bookmark_manager;
(to connect to correct db) - Run
03_add_title_to_bookmarks.sql
- Connect to postgres in terminal
psql postgres
- Run
psql \c bookmark_manager_test;
(to connect to correct db) - Run
03_add_title_to_bookmarks.sql