PostgreSQL Data Access

FerretDB stores data in PostgreSQL JSONB columns. You can query documents directly with SQL for analytics and reporting.

Syntax

ferretdb

SELECT data->>'field' FROM schema.collection WHERE data->>'field' = 'value';

Example

ferretdb

-- Query directly in PostgreSQL
SELECT data->>'name', data->>'email'
FROM myapp.users
WHERE data->>'role' = 'admin';

-- Analytics
SELECT data->>'tier', COUNT(*)
FROM myapp.users
GROUP BY data->>'tier';