⭐ FeaturedIntermediate
PostgreSQL Advanced Queries
postgresql development guide
Full Prompt
Write advanced PostgreSQL queries and optimizations: window functions for running totals and rankings, recursive CTEs for hierarchical data, JSONB operators for document queries, full-text search with tsvector, materialized views for reporting, partitioning strategies for large tables, and EXPLAIN ANALYZE interpretation guide with real examples.
Tags
Works with
✨Claude 3.5 Sonnet✨GitHub Copilot✨Cursor
Beginner Rating
4.1(3,519)
Stats
10,067Views
330Copies
3,519Likes
330Saves