I am using PostgreSQL. I have two tables. Each having there own metric. I want to sum the metrics having same uid in each table induvidually and show them. Consider I have table A uid metric_1 timestamp a1. 10. x…
I have some SQL scripts that I'd like to convert into Liquibase XML changelogs. Is this possible?
I'm currently learning Spring-Boot and Spring-Data-JPA. I'm using a postgresql database for storing the data. My goal is to store ingredients with a unique and custom ID (you just type it in when creating it), but when another ingredient with…
I installed PostgreSQL and pgAdmin 4 on windows 10. Everything works in pgAdmin, but when i try to use psql i get this error: After running 'help', i can not run any option such as ? or q. If i…
I have an unusual problem I'm trying to solve with SQL where I need to generate sequential numbers for partitioned rows but override specific numbers with values from the data, while not breaking the sequence (unless the override causes a…
I have two classes - Role and PosUser. public class Role : IEntity { public string Name { get; set; } [Column(TypeName = "jsonb")] public string[] Permissions { get; set; } public bool IsProtected { get; set; } public uint…
I have a huge table data where sample data is like below. I want to filter few latitude and longitude records from the huge table and I am using In clause to filter list of lat,lon values but when I…
I am re-writing some old VB code to C# and converting everything to postgresql from informix and sql server. I am quite stuck on an issue that I believe is a data type issue due to postgresql being stricter with…
I am trying to get the source and target where source is 270 and the column is jsonb and values like [{"source": 270, "target": 285}, {"source": 427, "target": 285}, {"source": 285, "target": 285}] The expected output is {"source": 270, "target":…
I am not a regular user of Postgresql, I have read some documentation but I am afraid to run the wrong query and I do not want to damage a database in production. I need to edit the url field…