DEV Community

Moiz Ibrar
Moiz Ibrar

Posted on • Updated on

Initializing and Creating a Testing Database in PostgreSQL 12.0 with Age Part 3

Postgres is already installed in your system.
Now you have to create age extension.

Configure Age with PostgreSQL

Create the Age extension by running the following command in the PostgreSQL database:

CREATE EXTENSION age;
Enter fullscreen mode Exit fullscreen mode

load the extension for age:-

LOAD 'age';
Enter fullscreen mode Exit fullscreen mode

Set the search path and other variables.

SET search_path = ag_catalog, "$user", public;
Enter fullscreen mode Exit fullscreen mode

This command sets the search path to include the Age catalog, the current user's schema, and the public schema. This allows you to use the Age functions and operators in your queries.

By following these steps, you can configure Age with PostgreSQL and use its powerful functionality in your database queries.
Apache-Age:-https://age.apache.org/
GitHub:-https://github.com/apache/age

Top comments (0)