May I know on how to call an array in stored procedure? I tried to enclosed it with a bracket to put the column_name that need to be insert in the new table. CREATE OR REPLACE PROCEDURE data_versioning_nonull(new_table_name VARCHAR(100),column_name VARCHAR(100)[],…
I have a MySQLdump generated by PHPMyAdmin, and I need to import it into a Postgresql database, but I dont know if it's even possible. I've seen people recommending pgloader but seens a little confusing on how to do it.…
model Comment { id Int @id @default(autoincrement()) cid String bid String author AppProfile @relation(fields: [bid], references: [bid]) comment String created DateTime @default(now()) } const results = await prisma.comment.create({ data: { cid: req.body.cid, comment: req.body.comment, bid: appProfile.bid, }, }); prisma:query INSERT…
How does the code look like to partition the following table. date and status are given, partition column shall be added. Column group is only to explain where the group starts and ends. Finally, I like to do some analytics,…
select max(to_number(ltrim(aefo_number,'VE'))) from exemption where aefo_number like 'E%' or aefo_number like 'V%' I am getting Function to_number(text) does not exist error for the above select statement and I am unable to convert it. If anyone know the syntax for the…
I have following idea: user can edit database and when he will press exit from database he will be asked if he want to save edited database or if he edited something and then turned it back he wont be…
Lets say I have function that triggers when table is being updated. Then it tries to send this data as json into remote database via dblink: statement := 'INSERT INTO mytable(my_data) VALUES (''' || my_json || ''')'; PERFORM dblink('my connection…
I have a database with over 30,000,000 entries. When performing queries (including an ORDER BY clause) on a text field, the = operator results in relatively fast results. However we have noticed that when using the LIKE operator, the query…
I use PostgreSQL 14 to work on a student_books table which manages books borrowed by students. Each student can have zero or more books borrowed at any point in time. The table look like this (the order of rows doesn't…
I have a JSON column, telework, stored in Postgres which looks like "{ ..., "biweeklyWeek1-locationMon": "alternative", "biweeklyWeek1-locationTues": "agency", "biweeklyWeek1-locationWeds": "alternative", "biweeklyWeek1-locationThurs": "alternative", "biweeklyWeek1-locationFri": "alternative", ... , "biweeklyWeek2-locationMon": "alternative", "biweeklyWeek2-locationTues": "agency", "biweeklyWeek2-locationWeds": "alternative", "biweeklyWeek2-locationThurs": "alternative", "biweeklyWeek2-locationFri": "alternative", ... }" I need…