[AG] SampleData Import(movie_graph)

Ja L·2023년 3월 22일
0

GDB

목록 보기
1/2

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

profile
DB Engineer

0개의 댓글