# Installation from Source Code

With the Shell Script

Get the source by either, download the code as ZIP file, or by git clone.

You will find the sources on Codeberg.

Enter the directory where you have unpacked the ZIP file or stored the repository.

cd pgsql_tweaks
make install

Afterwards you are able to create the extension in a database:

CREATE EXTENSION pgsql_tweaks;

With The SQL file

Each version has its own SQL file, which is used by the PGXN package and also by the RPM package.

The folder sql/out/versions/ contains all SQL version files.

That way you can even install pgsql_tweaks in cloud environments where pgsql_tweaks is not available.