28 Working with Files Using the Graph Server (PGX)
This chapter describes in detail about working with different file formats to perform various actions like loading, storing, or exporting a graph using the Graph Server (PGX).
In order to read or write files, you need to explicitly authorize access to the corresponding directories by defining a directory object pointing to the directory (on the graph server) that contains the files to read or write.
CREATE OR REPLACE DIRECTORY graph_files AS '/data/graphs/my_graphs';
GRANT READ, WRITE ON DIRECTORY graph_files TO GRAPH_DEVELOPER;
Also, note the following:
- The directory in the
CREATE DIRECTORY
statement must exist on the graph server (PGX). - The directory must be readable (and/or writable) at the OS level by the graph server (PGX).
The preceding code grants the privileges on the directory to the
GRAPH_DEVELOPER
role. However, you can also grant permissions to an
individual user:
GRANT READ ON DIRECTORY graph_files TO <graph_user>;