databasepostgresqlgraph-databasesapache-age

create_graph Function does not works


I have done:

test=# SET search_path = ag_catalog, "$user", public;

But still I can not use create_graph function directly.

test=# create_graph('university');
ERROR:  syntax error at or near "create_graph"
LINE 1: create_graph('university');

Why I need to do this using ag_catalog:

test=# SELECT * FROM ag_catalog.create_graph('university');

Solution

  • You encountered a syntax error because you failed to use the SELECT statement, try modifying your query;

    SELECT create_graph('university');
    

    or

    SELECT * FROM create_graph('university');