Today I got an email from a friend of mine that locked out of his own database due to a little mistake.
A few months ago I set up a Foreign Data Wrapper against a Microsoft SQL Server to import historical data. I’m quite impressive about how quick the bulk import is.
I was wondering about writing a function that provides a quick status about partitioning. But wait, PostgreSQL has recursive CTEs!