DEV Community

Damil Shahzad
Damil Shahzad

Posted on

Database Initialization and Creation for Testing in PostgreSQL 12.0 with Age (Part 3)

Now that Postgres is installed on your system, it's time to create an age extension.

Use the following command to create the Age extension in PostgreSQL:

CREATE EXTENSION Age;

Load the extension:

LOAD 'Age';

Set the search path and variables:

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

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

Now the PostgreSQL is configured, and ready to use

Visit Apache Age's official website: Apache-Age:-https://age.apache.org/

Visit Apache Age's Github account:
GitHub:-https://github.com/apache/age

Top comments (0)