I am new into databases and PostgreSQL and today I wanted to import this dataset: https://www.kaggle.com/datasets/wilmerarltstrmberg/recipe-dataset-over-2m/data into a PostgreSQL so I can make a recipe finder app. I started by creating a new database, then creating a table and then…
api git:(main) ✗ pnpm prisma migrate dev Environment variables loaded from .env Prisma schema loaded from prisma/schema.prisma Datasource "db": PostgreSQL database "postgres", schema "public" at "localhost:2010" Error: P1000: Authentication failed against database server at localhost, the provided database credentials for…
I'm learning PostgreSQL and want to understand the exact order in which SQL statements are evaluated. After researching, I found the following evaluation order: 1. FROM 2. ON 3. JOIN 4. WHERE 5. GROUP BY 6. HAVING 7. SELECT 8.…
| Column A | character varying[] | ------------------------ | | {value1,value2,value3} | Tried with select * from some_table where columnA LIKE '%value1%' but it returns error. Then tried filtering expected value by using select columnA from some_table but now it…
There is a table of customers with purchases made in a certain month. It happens that a customer did not buy anything in a certain month, so this month is skipped. Task: I need to extract only those lines where…
I have a column called tags of type JSONB in my PostgreSQL table called EMPLOYEE. There is a use case where I want to allow users to query this JSONB column, i.e., tags. Users can give inputs like: tags.inoffice.present =…
In general, I have a working query which is "Having A or B". It works, but I also want to add one more statement. I tried "Having (A and C) or (B and C)" -> gives no user_id, tried "Having…
I have a table that has users' activiies on their membership (activate or deactivate) and when those activities happened. The activity table look like this: user_id activity date 123 activate 06/01/2024 123 deactivate 06/15/2024 123 activate 06/20/2024 123 deactivate 06/30/2024…
I have below dataset, 1. '{SHEET,2730377,SHEET,5708283,DATA,3015937}' 2. '{SHEET,2730377,SHEET,5708283,DATA,3015937,DATA,0010965}' 3. '{SHEET,5708283,DATA,3015937,DATA,0010965}' 3. '{SHEET,5708283,DATA,3015937}' I need the result as, 1. {DATA,3015937} 2. {DATA,3015937,DATA,0010965} 3. {DATA,3015937,DATA,0010965} 4. {DATA,3015937} Basically I wanted to replace SHEET followed by 7 digit number and extract only DATA…
I have two related tables as below. Master table: ID Date Rev 1 2022-01-01 1 2 2022-01-02 1 3 2022-01-02 2 4 2022-01-03 1 Detail table: ID hour Capacity 1 1 1 1 2 2 1 3 3 1 4…