postgres=# create user lee with password '0000' superuser ;
postgres=# create database sampledb owner lee
postgres=# \c sampledb lee
You are now connectedto database "sampledb" as user "lee".
postgres=# \i cregraph_movie.sql
postgres=# \dt
List of relations
Schema | Name | Type | Owner
--------+----------+-------+---------
public | acted_in | table | lee
public | directed | table | lee
public | follows | table | lee
public | movie | table | lee
public | person | table | lee
public | produced | table | lee
public | reviewed | table | lee
public | wrote | table | lee
(8 rows)
postgres=# \dG
List of graphs
Name | Owner
-------------+---------
movie_graph | lee
postgres=# alter database sampledb set graph_path='movie_graph' ;
ALTER DATABASE