I tried exporting the data to CSV and importing it to the new database, but it does not seem to respect the case sensitivity of column names. "createdAt" becomes "createdat" and does not change even when trying to modify the…
I accidentally ran and committed drop schema information_schema cascade on postgres 15.4 as a DBA. How to recreate the said schema?
I'm trying to order a set of paged results based on the existence of many to many relationship. I can write a query by hand that does this, but I'm trying to figure out how to do this the sequelize…
I would like to import an Excel file in which times are formatted as "00:00" (minutes:seconds). The corresponding field in the database is designated as an integer. Which function can I use to enter the value and convert it to…
I have the following data in a PostgreSQL table: id amount opening_amount closing_amount 1 200 1000 1200 2 -500 NULL NULL 3 -200 NULL NULL 4 1000 NULL NULL I want to convert this data into a ledger format, calculating…
I am trying to create a SQL query to update a column in my table as shown here. Driver table: ID TripTotal 1 NULL 2 NULL 3 NULL 4 NULL Trip table: TRIP ID DRIVER ID TRIP 1 1 1…
Name Price Qty A 3 30 B 5 3 C 5 3 D 6 20 i have a table contain data like this. i want to get what is the maximum of sum(qty) that i can provide Price <= 100…
I have a table structure analogous to this towns (id, name, region_id) regions (id, name, country_id) countries (id, name) I need to enforce the uniqueness of town name within the country. In a given country, if we put together all…
As an example, if I have 3 users in Postgres, lets call them user_a, user_b, user_c... How can I ensure that they cannot hold more than two open connections at the same time? I may also have a user called…
I am setting up an Azure Data Factory that links to a Postgres SQL server that is hosted elsewhere. Several of our pipelines are failing to copy data from their source Postgres tables into their Azure SQL server sink tables.…