I have a unique index for a model that's not working. Here is my model const Script = sequelize.define('Script', { name: { type: DataTypes.STRING, allowNull: false, }, deletedAt: { type: DataTypes.DATE, allowNull: true }, }, { indexes: [ { unique:…
How to apply SET TIME ZONE to NpgsqlCommand? Attempt 1. SET TIME ZONE in CommandText, separated from select with ; using var cmd = connection.CreateCommand(); cmd.CommandText = "SET TIME ZONE '+02:00'; select "t0"."start_time" from "task"."tasks" "t0" where "t0"."number" = 217";…
Considering the case in which we've got two tables, say: SubscriptionPayments and OrderPayments inherit the shared table Payments. Is there a way to find out within the table Payments which table any record belongs to; in other words, is it…
I have this Entity class with nickname String as a key. @Data @Entity @Table(name="players") public class Player { @Id private String nickname; @Column(name="name") private String name; @Column(name="surname") private String surname; ... ... ... } Controller @PostMapping(value="/addPlayer", consumes = {MediaType.APPLICATION_JSON_VALUE}, produces…
I have a mysql database and i want to insert values similar to this one 12,3456.78. I tried using the float and double type but the result is rounded to 12 and using decimal is still not helping, i get…
Hi I have some questions regarding table functions in PostgreSQL From https://www.postgresql.org/docs/16/queries-table-expressions.html#QUERIES-TABLEFUNCTIONS CREATE TABLE foo (fooid int, foosubid int, fooname text); CREATE FUNCTION getfoo(int) RETURNS SETOF foo AS $$ SELECT * FROM foo WHERE fooid = $1; $$ LANGUAGE SQL;…
I have a category, percentage table in SQL (the table itself has been obtained by the following query: SELECT p.category, sum(p.sales) * 100 / sum(sum(p.sales)) OVER () AS percentage FROM product p GROUP BY p.category; Category Percentage Books 20.51% Clocks…
I have two tables: DOCUMENT and ITEM. Each DOCUMENT has multiple ITEMS, so ITEM has a foreign key to DOCUMENT, let's name it document_id. I want to write a query, to get the total number of documents, that have specific…
I have the following batch file in windows, in order to backup postgresql daily. I will add this batch file to run daily at specific time in Task Scheduler. pg_dumpall --exclude-database='template1' --host=127.0.0.1 --port=1234 --username=myuser --password=mypass > mydb_export_all.sql However, postgresql contains…
I have a table with login names. Login names does not contain any special character just [a-zA-Z0-9] and of type varchar(50). I would like to find a user by login name eg.: CREATE TABLE users( login character varying(50) ); INSERT…