PostgreSQL Extensions
Enable powerful PostgreSQL extensions to extend your database capabilities.
What are Extensions?
PostgreSQL extensions add specialized functionality to your database — from geospatial queries (PostGIS) to encryption (pgcrypto) to advanced data types (hstore, uuid-ossp).
Lordbase provides a curated list of safe extensions that can be enabled on any PostgreSQL database.
Listing Available Extensions
curl -X GET https://api.lordbase.com/e/v1/developer/databases/{database_id}/extensions/ \
-H "Authorization: Bearer lb_pat_your_token"
To see the list of all supported safe extensions:
curl -X GET https://api.lordbase.com/e/v1/developer/extensions/safe/ \
-H "Authorization: Bearer lb_pat_your_token"
Enabling an Extension
curl -X POST https://api.lordbase.com/e/v1/developer/databases/{database_id}/extensions/uuid-ossp/enable/ \
-H "Authorization: Bearer lb_pat_your_token"
Disabling an Extension
curl -X POST https://api.lordbase.com/e/v1/developer/databases/{database_id}/extensions/uuid-ossp/disable/ \
-H "Authorization: Bearer lb_pat_your_token"
warning
Disabling an extension may cause errors if your application depends on extension-provided types or functions.
Popular Extensions
| Extension | Description | Use Case |
|---|---|---|
uuid-ossp | UUID generation functions | Primary keys, unique identifiers |
pgcrypto | Cryptographic functions | Password hashing, encryption |
hstore | Key-value store type | Flexible metadata storage |
pg_trgm | Trigram text similarity | Full-text search, fuzzy matching |
postgis | Geospatial data types and queries | Location-based applications |
btree_gin | GIN index support for B-tree types | Multi-column indexing |
citext | Case-insensitive text type | Email fields, usernames |
Next Steps
- Connection Pooling — Configure PgBouncer
- Query Analytics — Monitor extension performance