How to View ParadeDB Open Source License in PostgreSQL

Galaxy Glossary

How do I view the ParadeDB open source license from PostgreSQL?

Displays the ParadeDB extension’s OSS license text directly from your PostgreSQL session.

Welcome to the Galaxy, Guardian!
You'll be receiving a confirmation email

Follow us on twitter :)

Oops! Something went wrong while submitting the form.

Description

Example H2

Example H3

Why would I need to check ParadeDB’s license?

Confirming an extension’s license lets legal and engineering teams validate compliance before shipping code to production or redistributing software.

How do I list installed extensions and locate ParadeDB?

Run SELECT * FROM pg_extension;. Verify paradedb appears with its version so you know the path PostgreSQL used during CREATE EXTENSION.

What SQL shows the exact license file?

PostgreSQL stores extension scripts under $SHAREDIR/extension. Query pg_extension and concatenate the directory to build the full path, then call pg_read_file() to stream the text.

Example step-by-step

1. Identify the share path: SHOW shared_preload_libraries; 2. Read the license: SELECT pg_read_file(pg_extension_config_dump_filename(e.oid)::text || '/../../../LICENSE') AS license_text FROM pg_extension e WHERE e.extname = 'paradedb';

Can I inspect the license from psql without SQL?

Yes. In psql type \! to execute shell commands, then cat $(pg_config --sharedir)/extension/paradedb--*.sql | grep -A5 'LICENSE'.

What should I look for in the license?

Check the license type (e.g., Apache-2.0), notice any “Commons Clause” or usage restrictions, and record the commit SHA for auditing.

Best practices for OSS license audits

Automate checks in CI using license_finder, store authoritative copies in your repo, and re-run audits whenever you upgrade ParadeDB.

Can I redistribute ParadeDB inside SaaS?

Read the grant section of the license. Apache-2.0 and MIT generally allow commercial redistribution, but confirm any additional files (models, data) follow the same terms.

Why How to View ParadeDB Open Source License in PostgreSQL is important

How to View ParadeDB Open Source License in PostgreSQL Example Usage


-- E-commerce context: Legal team audits all loaded extensions before launching a new feature
SELECT c.name                   AS customer,
       o.order_date,
       pg_read_file(CONCAT((SELECT setting FROM pg_settings WHERE name='sharedir'),
                           '/extension/', e.extname, '--', e.extversion, '.sql')) AS license_text
FROM   Customers  c
JOIN   Orders     o ON o.customer_id = c.id
JOIN   pg_extension e ON e.extname = 'paradedb'
WHERE  c.id = 42;

How to View ParadeDB Open Source License in PostgreSQL Syntax


-- Locate ParadeDB and read its license in one shot
SELECT pg_read_file(
        CONCAT((SELECT setting FROM pg_settings WHERE name='sharedir'),
               '/extension/paradedb--', extversion, '.sql')
       ) AS license_sql
FROM   pg_extension
WHERE  extname = 'paradedb';

Common Mistakes

Assuming the LICENSE file sits in the extension directory on every machine. Some container images exclude doc files. Fix by using pg_read_file so PostgreSQL itself resolves the path.
Hard-coding a version number in the path (e.g., paradedb--0.3.sql). Upgrade will break the script. Use the dynamic extversion column instead.