I have a requirement to insert new records and delete this record 3 months after created date. I will create a new table. I want that query will create the table as well as auto delete the records which are…
I have a Products table where prices of products are updated every day. eff_date product_id price 2022-11-25 P1 150 2022-11-25 P2 75.8 2022-11-25 P3 2.9 2022-11-26 P1 180.5 2022-11-26 P2 77 2022-11-26 P4 13.92 But sometimes not all products will…
I'm trying to configure firewalld on my VPS server and I'm trying to open a port for my postgresql server. So far, I have done the following: sudo firewall-cmd --new-zone=postgresqlrule --permanent sudo firewall-cmd --reload sudo firewall-cmd --permanent --zone=postgresqlrule --add-port=5432/tcp sudo…
I want to perform a fill-down activity in PgSQL DDL: create table brands ( id int, category varchar(20), brand_name varchar(20) ); insert into brands values (1,'chocolates','5-star') ,(2,null,'dairy milk') ,(3,null,'perk') ,(4,null,'eclair') ,(5,'Biscuits','britannia') ,(6,null,'good day') ,(7,null,'boost') ,(8,'shampoo','h&s') ,(9,null,'dove'); Expected output is: category…
Say I have two tables: tb1: id name date 1 John 01/01/2012 1 John 01/02/2012 2 James 02/02/2020 tb2: id name date 1 John 01/01/2013 1 John 01/01/2012 The uniqueness of both tb1 and tb2 comes from the combination of…
I'm on Postgres 13 and have a table like this | key | from | to ------------------------------------------- | A | 2022-11-27T08:00 | 2022-11-27T09:00 | B | 2022-11-27T09:00 | 2022-11-27T10:00 | C | 2022-11-27T08:30 | 2022-11-27T10:30 I want to calculate the…
Trying to exploit SQL injection for my assignment. Is it possible to execute delete or drop query after order by in select query without using the semicolon in Postgresql? This is my sample query: Select * from table order by…
I have a query where I filter a column based on a where clause, like so: select * from table where col = val What value do I set for val so that there is no filtering in the where…
I have a model which looks like this: class Category(models.Model): name = models.CharField(max_length=50) slug = models.SlugField() parent = models.ForeignKey( 'categories.Category', null=True, blank=True, on_delete=models.CASCADE, related_name='categories' ) basically, in the parent field, it references itself. If a parent is set to None,…
For automated testing we can't use a DB Docker container with a defined volume. Just wondering if there would be available an "offical" Postgres image with no mounted volume or volume definitions. Or if someone has a Dockerfile that would…