I am trying to formulate a query in PostgresSQL, my table looks like this: Master_Account Sub_Account Cost 123 777 15 123 888 10 123 999 20 456 111 10 456 222 -15 789 789 10 I am trying to select…
I have a Postgresql database with the following tables and relations (fiddle): page: id, name book: id, page.id chapter: id, page.id, book.id section: id, page.id, chapter.id I'd like to create a (materialized) view that is able to associate every page…
Question When working with SQL, I am familiar with preparing SQL statements, and then either committing them if nothing goes wrong, or bailing out if something does (which to my understanding leaves the database unchanged). I am now however in…
I'm trying to figure out how exactly ON and WHERE work when doing a JOIN My understanding based on other questions is that I should filter in where when the condition is on the left side of the join, and…
We are in the process of setting up a process to read log files and generate long-running query reports in PostgreSQL. However, we are looking for a configuration setting that allows us to track only stored procedure or function calls,…
I have a table and it has a column start_date. I have two variable fields/filters from_date and to_date on which I want my records to be filtered. I am working on a SQL/PostgreSQL/pgAdmin4 script that returns all the rows whose…
I have the following table: create table table1 ( id serial, workdate date, col1 varchar, col2 varchar, col3 varchar ); And I have inserted the following data: insert into table1(id, workdate) values (DEFAULT, '01/12/2023'); Now I updated it, looking to…
Let's suppose we have two queries (I use postgresSQL with psycopg2): 1 - query= """ SELECT * FROM same_table """ 2 - query= """ SELECT * FROM same_table WHERE id = %(some_id)s """ Is it possible to crate a single…
Perhaps the question sounds vague and unclear. Now I will try to clarify the situation. I have a backend on Spring Boot and Postgresql. I am trying to deploy docker for development with a frontend developer. The containers are running,…
I am getting these errors (please see below) after I restart my psql database. This occurs after i install pgaudit and adding pgaudit on my postgresql.conf. I wonder what am i missing, is it a problem on pgaudit installation? 2024-01-22…