There are tables: groups, targets and join table groups_targets. Groups have targets, for example: Group #1 has a gender target, an age target, and a city target Group #2 has a gender target Group #3 has a city and gender…
I want to give a group of users selective access only to particular columns of an Application due a privacy concern. So, when user types '''SELECT *''' on restricted table, he could only see allowed columns. What I want to…
I've been stumped trying to optimize this query and was hoping some of you database wizards might have some insight. Here is the setup. Using TimescaleDB as my database, I have a wide table containing sensor data, it looks like…
I have a table with such structure: id product company 1 table A 2 table B 3 table C 4 chair A 5 chair B 6 sofa A 7 sofa C I need to find all products whose companies include…
Docker Desktop 4.21.1 (114176) docker-compose file: # Use postgres/example user/password credentials version: 'latest' services: db: image: postgres restart: always environment: POSTGRES_USER: dbadmin POSTGRES_PASSWORD: mypassword POSTGRES_DB: testdb volumes: - /Volumes/Development/directories/workspace/postgres/data:/var/lib/postgresql/data adminer: image: adminer restart: always ports: - 9080:9080 Docker containers start…
i have table in database called land with a field landType , landType is an array of strings (string[]) i need to write a query that by taking an input for example "N" it returns the row if any of…
I have a SQL statement like this: insert into table1 (col1, col2, col3, col4) select value1, value2, now(), now() from othertable inner join anotherothertable on somecolumn = someothercolumn; The select component of this query will return many hundreds of thousands…
I have groups that have a jsonb field - targets my sql SELECT DISTINCT groups.* FROM groups WHERE groups.user_id = 1 AND ( EXISTS ( SELECT * FROM jsonb_array_elements(targets) as a WHERE a->>'name' ~* 'gender|age' ) ) this will return…
I am looking for hash function, that I can use in Postgresql to be more specific in Amazon Aurora Db. The Hash value generated should be of 8 bytes long that can be stored in string field of length 8.…
I installed PostgreSql and checked if extention 'uuid-ossp' was there. CREATE EXTENSION IF NOT EXISTS "uuid-ossp"; And I checked the results with sql query. SELECT * FROM pg_available_extensions; enter image description here However, the uuid_generate_v4() function cannot be used when…