Is there any way so that I use Apache AGE extension in pgAdmin ?
Question posted in PostgreSQL
The official documentation can be found here.
The official documentation can be found here.
Is there any way so that I use Apache AGE extension in pgAdmin ?
2
Answers
You just need to:
psql -U username dbname
CREATE EXTENSION AGE;
LOAD 'age';
SET search_path = ag_catalog, "$user", public
;Then you should be able use AGE extension in pgAdmin since its an IDE.
I also found this answer about installing extension in pgAdmin.
Yes, you can do it.
firstly download and install Apache AGE on your machine. If you need help installing apache age read this.
Then install pgAdmin on your local machine or server. You can download pgAdmin from the official website.
Right-click on the database and select "Query Tool" to open the SQL editor.
In the SQL editor,run "CREATE EXTENSION age;" without quotes.
You can now use Apache AGE commands and functions in your SQL queries to perform graph-related operations.