I am trying to define custom function and I wanted to find how can I calculate estimated cost of that function https://www.postgresql.org/docs/current/sql-createfunction.html I tried giving different values of cost function but unable to find to find how to estimate that…
I have a users table and a column supervised_by where I want the id of the user who created the new user. For example: get the id of the admin in supervised_by column of the user the admin creates. users…
I try to connect from backend container to postgres container. Here is my docker-compose file: version: "3.9" services: imgress-producer: build: context: ./producer dockerfile: Dockerfile.producer target: prod container_name: imgress-producer ports: - 8080:8080 environment: - POSTGRES_USER=${POSTGRES_USER} - POSTGRES_PASSWORD=${POSTGRES_PASSWORD} - POSTGRES_DB=${POSTGRES_DB} - DATABASE_HOST=${DATABASE_HOST}…
String contains words separated by spaces. How to get substring from start until first uppercase word (uppercase word excluded)? If string start with uppercase, this word should included. Search should start from secord word. First word should always appear in…
I have 2 tables 1) users 2) user_companies. A user belongs to or has one company, A company has many users. This is how I determined my relationships. How can I pull company data for each user? Attempt to read…
Joining 2 tables (orders, addresses) Orders contains columns delivery_address_id (contains NULL values) and invoice_address_id (does NOT contain NULL values) Addresses contains id column (does NOT contain NULL values) Primarily, the LEFT JOIN must be performed on orders.delivery_address_id. However, in the…
The timestamps my database returns are in this format: '2022-11-25T17:54:29.819Z' I want to do hour(timestamp) to return just the hour but get this error 'error:"function hour(timestamp with time zone) does not exist"' How do I get around this? Thanks!
When I`m trying to connect Django Server to PostgreSQL db there is an error: " port 5433 failed: Connection refused Is the server running on that host and accepting TCP/IP connections? " I`m using Windows 10, Pycharm, Debian Settings in…
dictionary = testEns(idSession) columns = dictionary.keys() for i in dictionary.values(): sql2='''insert into PERSONS(person_id , person_name) VALUES{};'''.format(i) cursor.execute(sql2) The function testEns(idSession) contains the result of an api call that returns an xml response that has been transformed into a dictionary. i'm…
Lets supose I have a tabla A like: bisac1 bisac2 bisac3 desire x y z 10 y z x 8 z y x 6 x y p 20 r y z 13 x s z 1 a y l 12…