PostgreSQL type to store and work with data in double precision pascals while representing and in/out in decibels.
postgres=# CREATE EXTENSION decibel; CREATE EXTENSION postgres=# SELECT 65.23::decibel; decibel ─────────── 65.23 (1 row)
As long as pg_config is on the path (utility installed with PostgreSQL that should be on the system, if not, might need postgresql-dev or something) running this in the directory should build and install the extension on the system:
make clean; make; sudo make install;
From there you need to actually add it to the database by going into the database and running:
CREATE EXTENSION decibel;
If you want to get rid of it (or ditch it, then upgrade it) you can run DROP EXTENSION decibel; This will only work if you get rid of any tables with decibel columns. DROP EXTENSION decibel CASCADE; will remove any columns or other objects using the extension.