Hire Expert PostgreSQL
Developers from India

-- Row-level security for multi-tenant SaaS CREATE TABLE orders ( id UUID DEFAULT gen_random_uuid() PRIMARY KEY, tenant_id UUID NOT NULL REFERENCES tenants(id), amount NUMERIC(12,2) NOT NULL, status TEXT DEFAULT 'pending', created_at TIMESTAMPTZ DEFAULT NOW() ); ALTER TABLE orders ENABLE ROW LEVEL SECURITY; CREATE POLICY tenant_isolation ON orders USING (tenant_id = current_setting('app.tenant_id')::UUID); -- Partial index for fast pending order queries CREATE INDEX idx_orders_pending ON orders (tenant_id, created_at DESC) WHERE status = 'pending';