So, I was deploying the django app to production and then the infamous postgres deadlock situation happened. This happens during the django migration. Django ve
I have some lines of SQL which will take a set of IDs from the same GROUP_ID that are not contiguous (ex. if some rows got deleted) and will make them contiguou
I'm trying to create a linked service on Azure Data Factory V2 (from my personal subscription) to an Azure PostgreSQL database hosted by company A (on a differe
I am using Windows 10 I have a PostgreSQL file when I run inside the PSQL CMD \i FILENAMEPATH postgres=# \i C:\Users\Asus\Desktop\Projects\Movies\solution.sql C