Contents

• my_extension
  • Overview
  • Features
  • Installation
    • Requirements
    • Steps
  • Usage
    • Creating a custom table
    • Adding two numbers
    • Adding multiple numbers
  • Contributing
  • License

my_extension

Overview

my_extension is a basic PostgreSQL extension that provides additional functionality for efficient data manipulation and calculations.

Features

• Create a custom table my_table with an auto-incrementing id column and a name column.
• Implement a function add(a, b) that returns the sum of two integers.
• Implement a function complex_add(numbers) that returns the sum of multiple integers provided as an array.

Installation

Requirements

• PostgreSQL (version 9.6 or later)
• Git

Steps

1. Clone the repository: git clone https://github.com/IshaanAdarsh/Postgres-extension-tutorial/tree/main/Code/my_extension

2. Change to the extension directory: cd my_extension

3. Build and install the extension: make make install

4. Enable the extension in your PostgreSQL database: CREATE EXTENSION my_extension;

Usage

Creating a custom table

Table is created when the extension is Created automatically with an auto-incrementing id column and a name column.

Adding two numbers

To add two numbers using the add function, execute the following SQL query:

SELECT add(1, 2);

Adding multiple numbers

To add multiple numbers using the complex_add function, provide an array of integers and execute the following SQL query:

SELECT complex_add(ARRAY[1, 2, 3, 4, 5]);

Contributing

Contributions are welcome! If you have any suggestions, bug reports, or feature requests, please open an issue or submit a pull request.

License

This project is licensed under the PostgreSQL License.