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…
I have a springboot 3 application, pretty standard, which has a Controller, a service that is called by the controller and a repository that the service uses to fetch and save data. I had configured my application to work with…
I'm working on a project that uses Quarkus with Panache and PostgreSQL, and I'm trying to store JSON data as JSONB in the database. However, when I insert JSON data into the database, it gets escaped, and I'd like to…
My goal is to search for SKU values that are duplicated if we exclude special characters and get ids of those records. INSERT INTO sneakers (sneaker_id, sku) VALUES (1, '111-111'), (2, '111/111'), (3, '222-222'), (4, '333:333'), (5, '333-333'); In this…
I have a set of data that I group by "product_group_id", "group_name" and "class". Names of products for this group are different. CREATE TABLE rule ( product_id integer , product_group_id integer , group_name text , class text , name text…
I am creating a function in postgres which is created but does not have the permissions to be accessed by the application. It is giving me WARNING: no privileges were granted for "public" I restarted with "open as administrator" option,…
I have question regarding fetching foreign key in GORM. I am using golang and POSTGRES for my database. AFAIK, Preload(clause.Associations) will fetch the foreign key from our database. If we are using Gorm .Find(&model), its automatically fetching my foreign key…
I have a query to get all penalty data with latest prices. In prices table there are many prices related to a product. To take the valid price I need to get the latest price. Here is the query. SELECT…
I have a table of products and another table of specific listings of these products. CREATE TABLE products (id INT AUTOINCREMENT); CREATE TABLE listings ( id INT AUTOINCREMENT, product INT REFERENCES products(id), vendor INT ) I want to select listings…
I am working with a PostgreSQL database where I have a query that unions 5000 tables with identical structures. The query is saved as a view. I've noticed that the planning time for this query is significantly longer than the…