I used to work with Oracle, where after creation of a new database user you need to grant them a few privileges, ex. to connect(CREATE SESSION) to the database or create a table(CREATE TABLE). Otherwise the user is useless and…
I need to update a specific value in a column with the json type. All solutions I found online are either for jsonb or don't seem quite right and give me an syntax error and I don't know why. That…
I recently started learning postgresql, and I had a little problem setting up relationships between tables. I have 2 tables - users and projects. Each project has its creator (user), and each user has an array with his projects. create…
I am trying to get distinct values from each column and not distinct row values. My Query is: SELECT DISTINCT ac.admin_id , sc.student_id , tc.teacher_id from contact c join admin_contacts ac on ac.`contact_id` = c.id join student_contacts sc on sc.`contact_id`=…
I have a table structure as follows: Shops Table: id shop_name 1 My Shop 2 Another Shop 3 Final Shop Orders Table: shop_id order_id data created_at 1 123 json 01/01/2023 2 456 json 01/01/2023 3 234 json 02/02/2023 1 765…
class Marriage(BaseModel): users = ArrayField(BigIntegerField) chat_id = BigIntegerField() class Meta: indexes = ( (('users', "chat_id"), True), ) I would like to make a unique index for both user values and chat_id for example: there is already such a row in…
so I want to build a intventory Management database. My schema looks like this: Database Schema An Itemclass (screwdriver, hammer, measuring device,...) can have many items (screwdriver1, screwdriver2,...) Everything is fine and working as expected. But now i want to…
I am new to React Native and app development. So I am making a basic app that once opened, a modal opens up for use to login. User authenticates with Supabase, and then modal goes away to user can start…
I have the following table: create table table1 ( id serial, workdate date, col1 varchar, col2 varchar, col3 varchar ); And I have inserted the following data: insert into table1(id, workdate) values (DEFAULT, '01/12/2023'); Now I updated it, looking to…
I am taking over maintenance on some older ASP.NET projects. I see code like the following all over the place. Shouldn't the database objects be wrapped in using statements? The server is busy and runs for months as is without…