Database project (CS387)
cd
into the directory containing the filegame.sql
.- Open
psql
in that directory and create a new database with the namegame
:create database game
- Now connect to that database:
\c game
- Now import the file:
\i game.sql
- Now check if the database import succeeded:
\d
- If you don't see the tables, connect to
postgres
database by typing\c postgres
and then type :grant all on schema public to public;
- Now check again.
- If you don't see the tables, connect to