I was asked to add a column containg the bonuses of salary of employees, examples of this values were give such as: 1099.99 or 2.00. Task also asked me to add appropriate data type but I was confused which one…
I'm trying to make an API that uses PostgreSQL to store shortened links. However, when trying to execute a query to the database, postgreClient is undefined every time. short.controller.ts: import { Request, Response, NextFunction } from "express"; import client from…
I have got the following Postgres table: create table test ( id serial, contract varchar, amount0 int, amount1 int, price double precision ); I would like to insert 100 rows of dummy data that conforms to the following: – In…
I'm trying to save all the information inserted by user into database, all the info are able to save except the pdf file. My code: usermanual.php <div id="usermanualModal" class="modal fade"> <div class="modal-dialog"> <form method="post" enctype="multipart/form-data" id="usermanualForm"> <div class="modal-content"> <div class="modal-header">…
I have tried to select a list of databases and select all tables from each database, ordering the first ten tables by their size - including their indexes- through PL/pgSQL, but I have had a problem to join the query…
I have table like this: news_to_category news_id category_id 1 1 1 2 1 3 2 1 2 2 2 3 3 1 3 2 4 1 4 2 4 4 5 2 5 3 5 4 And now I need…
I've created a column of usernames but the ids for each row is linked to another table. If a user is deleted, I'd like to change the username to 'Deleted'. So I'd like to allow for unique values except for…
I followed the floor documentation step by step. Entities, Dao, Converters and database have been created. Build_generator generated the model.g.dart files type but not the database.g.dart file. I encounter two errors: Could not generate `fromJson` code for `changeListener`. To support…
I have faced this scenario in one of my interview. There will one table with millions of records and the table is going to have only two columns id which is primary key and time_stamp which is of type date…
I'm making a copy of an nft website for practice and I'm getting an error when transferring data from one table to another in my postgresql database using python. sender table: collection_stats receiving table: tbl_general_assets ` import psycopg2 db_config =…