/postroll
What I Wish Someone Told Me About Postgres 
challahscript.com
Search results
What I Wish Someone Told Me About Postgres
From the blog
Posted 2024-09-20
Miscellaneous Postgres Commands
I switched over from SQLite to Postgres to power my site some months ago, and have found myself having to learn some new usage when interacting with the database. These are likely very old hat for anybody familiar with Postgres, but I find myself having to remind myself what they are.
Search tips
- Use
#{some tag}ortag:{some tag}to filter by tag; using this more than once will find results that match all tags. - Use
year:{year}to filter by year. If you use this multiple times, the last one wins. - Use
begin:{year-month-day}to restrict to results beginning on that day. Last one wins. - Use
end:{year-month-day}to restrict to results ending on that day. Last one wins.
Great article going over a bunch of things the author learned about Postgres over several years of working with it. The information on how to do JSONb queries alone is worth the read.