I'm Newbie in postgres. I wrote a function, which insert into table a data by portions(because there is too much data in the source table to do it all at once) from another table: CREATE OR REPLACE FUNCTION data_load(p_src_schema character…
Currently, while a project using Spring is in progress, DB search using JDBC template is being modified to use JPA. In this situation, it is burdensome to use the JAP repository, so I want to use the entity manager. I…
i have a table like this: name used time asd 10 15:00 bsf 15 15:00 asd 20 14:55 bsf 0 14:55 i need to make a query that returns values like this: the result i need for the grafana timeseries…
I read book Ultimate ASP.NET Core Web API. And there is a code first database creation using DbContext and IDesignTimeDbContextFactory<>. public class RepositoryContextFactory : IDesignTimeDbContextFactory<RepositoryContext> { public RepositoryContext CreateDbContext(string[] args) { var configuration = new ConfigurationBuilder() .SetBasePath(Directory.GetCurrentDirectory()) .AddJsonFile("appsettings.json") .Build(); var…
I have collect_set(label) values and wanted to convert it to string SELECT users, collect_set(label) as pets from users_table group by users; so that ["dog", "cat", "lion"] would become ["dog", "cat", "lion"] but in STRING format
I have two Postgres tables: 'user' with unique rows, and 'address' where a single user can have multiple addresses. I want to join specific 'user' row with one row from 'address' where the address.id is the highest max(id). I wrote…
I'm using Django and DRF searchFilter, which allows me to add fields to the view's 'search_fields' to allow searching in them. Django version is 3.2 (will probably upgrade to 4.2) and DRF version 3.12.2. Lately I've added a new field…
so I am trying to update the JSON file using this particular query, but everytime i run this, it throws the error and my database isnot updated. cursor = connection.cursor() updated_data = { "Name": "John", "Age": "53", "SSN": "374875430" }…
I have a table SliceStatements (DB: PostgreSQL) that has a column Payload. The column's datatype is String but the string is in json format. The json has field rows which is an array of objects. It is known that each…
Mine is Postgresql 13 version and could see some strange issues when I use Alter default privileges,let Me explain. I have logged in with Postgres user and created database called testdb with schema name called lab and 2 tables called…