PostgreSQL Administrator Account WITH NOLOGIN (recover your role)
Today I got an email from a friend of mine that locked out of his own database due to a little mistake.
written sometime in June 2019
|
Importing data from MSSQL is faster than I thought
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.
written sometime in June 2019
|
A recursive CTE to get information about partitions
I was wondering about writing a function that provides a quick status about partitioning. But wait, PostgreSQL has recursive CTEs!
written sometime in June 2019
|
Checking the sequences status on a single pass
It is quite simple to wrap a couple of queries in a function to have a glance at all the sequences and their cycling status.
written sometime in June 2019
|
Happy Birthday Java!
Java has just turned 24 years old. Happy Birthday Java!
written sometime in June 2019
|