I need to find all view based on table my_table. I try query select * from information_schema.views where view_definition ilike '%my_table%' and get empty table. That means I have no view based on my_table. But after trying to delete my_table…
I have a SQL table of date entries with three columns: date, item, and status. The table appears like this: date item status 2023-01-01 A on 2023-01-01 B on 2023-01-01 C off 2023-01-02 A on 2023-01-02 B off 2023-01-02 C…
for testing purposes, I need to create Postgres Database which will have Public access and will be available from anywhere. My current CloudFormation looks like this: --- AWSTemplateFormatVersion: "2010-09-09" Resources: VPC: Type: AWS::EC2::VPC Properties: CidrBlock: 10.0.0.0/16 EnableDnsSupport: true EnableDnsHostnames: true…
Delete Operation is not working. How can i fetch data and then delete it in a functional way? The code successfully run but it is not deleting data in database. Controller Class @DeleteMapping("/deleteUserById/{userId}") public Mono<ResponseEntity<String>> deleteUserById(@PathVariable Long userId) { return…
I have this working static query: SELECT companyname, companyid, incorporationcountryid, periodEndDate, filingdate, AVG(dataitemvalue) FILTER (WHERE menmonic = 'AT') as "AT", AVG(dataitemvalue) FILTER (WHERE menmonic = 'COGS') as "COGS" FROM aaa3 GROUP BY companyname, companyid, incorporationcountryid, periodEndDate, filingdate ORDER BY companyname,…
I need to temporarily disable all constraints and triggers of a schema in order to anonymize data in several tables. As there are dependencies between tables, I prefer to disable everything and once the anonymization treatment is over I can…
In PostgreSQL, I have a column receipt_id which will have comma separated values or a single value . Eg: I need to use the values in the third column with another table called Voucher in where condition . I have…
I've noticed that in older version of PG (example 13) when I had query like: select 1 where 1=1and 2=2 all was OK but i try this in PG 15 I get error: trailing junk after numeric literal at or…
I have a column in my dataset with the following format: hashtags 1 [#newyears, #christmas, #christmas] 2 [#easter, #newyears, #fourthofjuly] 3 [#valentines, #christmas, #easter] I have managed to count the hashtags like so: SELECT hashtags, (LENGTH(hashtags) - LENGTH(REPLACE(hashtags, ',', ''))…
I want to sort test last name and test2 last name so that the former comes before the latter. My understanding is that each character is compared from left to right until they differ and therefore the characters after those…